Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup issue
hi,
please look at the attached spreadsheet, can someone advice what is the issue with the highlighted cell? Why it is thrwoing NA error? Regards Umesh Banga Last edited by Umesh Banga : May 8th 12 at 11:48 AM Reason: forgot attachement |
#2
|
|||
|
|||
Quote:
Dear Umesh Banga, Good Morning. I did not understand what was your intention at the search process. IF your intention was to search for a EXACT value to get the data, then the VLOOKUP formula is wrong. IF your intention was to search for a APROXIMATED value to get the data then the VLOOKUP formula only works well IF the list is crescent ordered. I did a new column to show you how the formula can be. Take a look at it and tell me if it worked for you. Fell free to ask anything about your question. Have a nice day.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup issue
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 On Tue, 8 May 2012 10:39:23 +0000, Umesh Banga wrote: hi, please look at the attached spreadsheet, can someone advice what is the issue with the highlighted cell? Why it is thrwoing NA error? Regards Umesh Banga +-------------------------------------------------------------------+ |Filename: vlooku****ue.zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=370| +-------------------------------------------------------------------+ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Worksheet Functions | |||
Vlookup issue | Excel Worksheet Functions | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Discussion (Misc queries) |