#1
|
|||
|
|||
Excel VLOOKUP- Returns wrong value
Attached is my spreadsheet using the VLookup function. Two cells (highlighted in "Yellow" return the wrong value from the table. For whatever reason, the number 3 is not recognized. When I insert another number, the correct value from the table is inserted. So, it appears not to be an error in the formula. I tried entered information in a new spreadsheet (thinking the cell where the number 3 is was damaged). That did not work either.
Thanks for your help! |
#2
|
|||
|
|||
You have not locked the first part of the vlookup range - H10:$I$505
it should be $H$10:$I$505 By the time it gets down to 15, your look up isnt in the range |
#3
|
|||
|
|||
Thanks for your reply: Will try your solution.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup returns drop down list | andrew_milonavic | Excel | 5 | 11-17-2016 06:35 AM |
COUNTIFS with two criteria returns wrong result | Ted C | Excel | 3 | 01-19-2016 07:50 AM |
Vlookup returns inconsistent results | Jhnsnkth527 | Excel | 0 | 04-16-2015 12:36 PM |
Formula returns wrong value | bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |