Microsoft Excel
--
Questions
--
Followers
Top Experts
VLOOKUP #NAME? error
I am using a nested VLOOKUP - against two look-up areas.... It works for part of it - but then I get #NAME? error when not found on either. I've looked at the formula over and over but can't see where I'm off.
Logic:
if item in column k is not found in first area, then check to see if item in column l is found in second area.
Obtain value if found in one of the two areas.
Write out 'value not found' if nothing found in either.
Here's the formula:
=IF(ISNA(VLOOKUP(K5,tbl_Pr
Thanks for your help,
je
Logic:
if item in column k is not found in first area, then check to see if item in column l is found in second area.
Obtain value if found in one of the two areas.
Write out 'value not found' if nothing found in either.
Here's the formula:
=IF(ISNA(VLOOKUP(K5,tbl_Pr
Thanks for your help,
je
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
I reproduced your #NAME? error when data was not present on either worksheet. I fixed it by replacing the curly quotes surrounding "count Note found" with straight double quotes. In the formula below, I decided you meant "Not" rather than "Note".
Also, did you mean to search worksheets rather than actual Tables? And did you mean to search first for K5 and then for L5?
=IF(ISNA(VLOOKUP(K5,tbl_Process_File_Counts!$D$1:$G$51,4,FALSE)), IF(ISNA(VLOOKUP(L5,tbl_Process_File_Counts2!$E$1:$G$51,3,FALSE)),”count Not Found”, VLOOKUP(L5,tbl_Process_File_Counts2!$E$1:$G$51,3,FALSE)), VLOOKUP(K5,tbl_Process_File_Counts!$D$1:$G$51,4,FALSE))Also, did you mean to search worksheets rather than actual Tables? And did you mean to search first for K5 and then for L5?
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Sample file showing both formulas in highlighted yellow cells.
VLOOKUP--NAME-error.xlsx
VLOOKUP--NAME-error.xlsx
Thank you for the help! It worked perfectly.
je
je
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.