Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2021, 11:25 AM
texascpa texascpa is offline Excel VLOOKUP- Returns wrong value Windows XP Excel VLOOKUP- Returns wrong value Office 2010 64bit
Novice
Excel VLOOKUP- Returns wrong value
 
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, 8 views)
Reply With Quote
  #2  
Old 01-04-2021, 12:07 PM
Purfleet Purfleet is offline Excel VLOOKUP- Returns wrong value Windows 10 Excel VLOOKUP- Returns wrong value Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 01-05-2021, 09:55 AM
texascpa texascpa is offline Excel VLOOKUP- Returns wrong value Windows XP Excel VLOOKUP- Returns wrong value Office 2010 64bit
Novice
Excel VLOOKUP- Returns wrong value
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default

Thanks for your reply: Will try your solution.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VLOOKUP- Returns wrong value Vlookup returns drop down list andrew_milonavic Excel 5 11-17-2016 06:35 AM
Excel VLOOKUP- Returns wrong value 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
Excel VLOOKUP- Returns wrong value 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft