Formula Errors

Fix Excel LOOKUP and VLOOKUP #NAME? Errors After Filtering

Jason MillerJason Miller Nov 18, 2026 870 views

Question details

The user needs to resolve #NAME? errors in LOOKUP or VLOOKUP formulas that appeared after filtering Excel data.

Fix Excel LOOKUP and VLOOKUP #NAME? Errors After Filtering
Product
Microsoft Excel
Device & OS
not provided
Scenario
Filtering a worksheet that contains LOOKUP or VLOOKUP formulas.
Observed behavior
The lookup formulas return #NAME? after a filter is applied.
Before you start

Select an affected cell and inspect its formula in the formula bar. Note any named ranges, custom functions, or external workbook references it uses.

Solution 1Recommended

Check the formula and named ranges

Use this approach to find unrecognized function names, text, or named ranges in the affected formula.

1
Inspect the formula

Select an affected cell and check the formula bar for misspelled function names and text values missing double quotation marks. For example, a literal text lookup value should appear as "Apple", not Apple.

2
Verify named ranges

Open Formulas > Name Manager and check that each name in the formula exists, is spelled correctly, has the appropriate scope, and refers to the intended range.

3
Evaluate the formula

With the affected cell selected, open Formulas > Evaluate Formula and choose Evaluate repeatedly to identify the expression associated with the error.

4
Check function compatibility

Review any other functions nested inside LOOKUP or VLOOKUP and confirm they are supported by your Excel version. If a nested function is unsupported, replace it with a compatible formula or open the workbook in a version that supports it.

Check the formula and named ranges
Filters and #NAME?: A filter alone does not normally cause #NAME?. The error generally means Excel cannot recognize something in the formula.
Free Microsoft Office alternative

Work with lookup formulas in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move and review workbooks. It does not repair Excel-specific add-ins or settings.

Open and review worksheets containing LOOKUP and VLOOKUP formulasCompatible with Microsoft Excel XLS and XLSX formatsUse familiar spreadsheet menus and formula toolsMove between Office workbooks with a lightweight, easy-to-use suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does VLOOKUP show #NAME? instead of #N/A?

#NAME? usually means Excel does not recognize part of the formula, such as a misspelled function or undefined name. #N/A usually means a valid lookup formula could not find a match.

Can filtering rows cause a #NAME? error?

Filtering alone does not normally cause #NAME?. Check the affected formula in the formula bar and use Formulas > Evaluate Formula to investigate what Excel cannot recognize.

How do I check whether a named range exists?

Open Formulas > Name Manager and look for the name used in the formula. Check its spelling, scope, and referenced range.

Will automatic calculation fix a #NAME? error?

Automatic calculation can update a stale result, but it cannot correct an invalid name or missing function. Select Formulas > Calculation Options > Automatic, then fix any unrecognized parts of the formula.