Vlookup returns value from cell above

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:03 PM GMT

Question

VLOOKUP error

I am using the VLOOKUP function to return a value from a table. However I find that the value returned is from the cell ABOVE the cell I need. This is consistent for all values returned. Please see attached document which shows the formula I am using and the value returned.

Answer

Clare

I couldn't read the illustration in your attachment, but, I suspect that the problem has to do with the values in the table not exactly matching the value you are looking up. If your VLOOKUP formula has a fourth argument of False {=VLOOKUP(value, range, column, FALSE) } then you will get an error if their is not an exact match. You probably need to do that, if the lookup range is not in alpha-numeric order. Without the fourth argument of False, you will return the value from the row that is closest to the lookup value without going over. Sometimes VLOOKUPs need and exact match, and sometimes they don't. It depends on your situation.

Advertisement

©2017 eLuminary LLC. All rights reserved.