Thread: [Solved] Excel VLOOKUP- Returns wrong value
View Single Post
 
Old 01-04-2021, 12:07 PM
Purfleet Purfleet is offline Windows 10 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