Thread: [Solved] Excel VLOOKUP- Returns wrong value
View Single Post
 
Old 01-04-2021, 11:25 AM
texascpa texascpa is offline Windows XP Office 2010 64bit
Novice
  
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default 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!
Attached Files
File Type: xlsx VLOOKUP QUESTION.xlsx (12.7 KB, 10 views)
Reply With Quote