Fix Excel LOOKUP and VLOOKUP #NAME? Errors After Filtering
Question details
The user needs to resolve #NAME? errors in LOOKUP or VLOOKUP formulas that appeared after filtering Excel data.

- 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.
Select an affected cell and inspect its formula in the formula bar. Note any named ranges, custom functions, or external workbook references it uses.
Check the formula and named ranges
Use this approach to find unrecognized function names, text, or named ranges in the affected 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.
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.
With the affected cell selected, open Formulas > Evaluate Formula and choose Evaluate repeatedly to identify the expression associated with the error.
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 add-ins and calculation settings
Use these checks if the formula contains a custom function or the workbook is not recalculating as expected.
Compare the worksheet with the filter cleared
Use this check to see whether the error is tied to the visible rows or persists independently of filtering.
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.

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.




