Quote:
Originally Posted by Umesh Banga
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
|
<<<<<
HELP from BRAZIL
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.