Forum Discussion
Jheeljp
Apr 20, 2020Copper Contributor
VLOOKUP not working properly some values not being caught by VLOOKUP
Please checkout this 27 second video for more details I have a few numbers in cells and trying to match them using VLOOKUP. When i exit a cell the value changes and it gets caught by VLOOKUP o...
SergeiBaklan
Apr 20, 2020MVP
Lookup value is text, by re-entering it you convert it to number and VLOOKUP could find it, I guess lookup range has numbers.
You may convert all values to numbers or use VALUE(A1) instead of A1 in VLOOKUP()