vlookup issue

U

Umesh Banga

hi,

please look at the attached spreadsheet, can someone advice what is th
issue with the highlighted cell? Why it is thrwoing NA error?

Regards

Umesh Bang

+-------------------------------------------------------------------
|Filename: vlookupissue.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=370
+-------------------------------------------------------------------
 
G

Gord Dibben

When you use the argument of TRUE or nothing the list must be sorted
or you will get inexact returns.

I'm amazed you didn't see that G8 and G13 ID numbers don't exist yet
are returning values in those rows.

Add the false argument of =VLOOKUP(G9,lookup,2,FALSE) to see better
results.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top