troubleshooting Question

VLOOKUP #NAME? error

Avatar of j e
j e asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution62 ViewsLast Modified:
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_Process_File_Counts!$D$1:$G$51,4,FALSE)), IF(ISNA(VLOOKUP(L5,tbl_Process_File_Counts2!$E$1:$G$51,3,FALSE)),”count Note 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))


Thanks for your help,
je
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros