Vlookup returns value from cell above

Question

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.