• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

#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
0
pdvsa
Asked:
pdvsa
  • 3
1 Solution
 
jppintoCommented:
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
 
pdvsaAuthor Commented:
dang it.  I have been looking at too many numbers today.  thank you for the help.  
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now