#NA and Vlookup

Experts:  I am not sure why I get #NA for the attached.  

I have spent too much time on it.  I dont know why.  If someone could please let me know... thank you EE-LC.xlsx
pdvsaProject financeAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
This is simple! Just need to adjust the row number on your formula. You are looking from row 21 downwards, you should start on row 7, like this:

=IF(VLOOKUP($B10,'LC Database-JPM (Delete XCR)'!$A$7:$G$145,7,FALSE)="12011Y",-VLOOKUP($B10,'LC Database-JPM (Delete XCR)'!$A$7:$AM$145,23,FALSE),IF(VLOOKUP($B10,'LC Database-JPM (Delete XCR)'!$A$7:$C$145,3,FALSE)="12011",VLOOKUP($B10,'LC Database-JPM (Delete XCR)'!$A$7:$AM$145,23,FALSE),0))

jppinto
0
 
jppintoCommented:
Please take a look at the attached file.

jppinto
EE-LC.xlsx
0
 
jppintoCommented:
For example, your formula on cell H9 was looking for the value of TPTS-652436 that was on 24 of the other sheet. As the formula was starting to search from from 21 downwards, it would find your value. The formula on cell H10 was looking for the value of TPTS-675564 that was on row 13 of the other sheet, thus the formula wouldn't find it.
0
 
pdvsaProject financeAuthor Commented:
dang it.  I have been looking at too many numbers today.  thank you for the help.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.