|
|
#1
01-04-2021, 11:25 AM
|
|||
|
|||
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! 
|
|
|
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 |
Windows XP 
Office 2010 64bit
Threaded Mode