Apr 20 2020 09:10 AM
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 otherwise it doesn't get caught.
Apr 20 2020 09:47 AM
I didn't see what you're describing ... looked to me as if the vlookup worked.
Anyway, the actual spreadsheet is more useful than an image, even a moving image. Or a sample that illustrates in real time. So if you could upload that, one could be more specific.
VLOOKUP usually (not always, and not necessarily) is looking for static reference values... because the table in which they do the looking up is usually (not necessarily) static itself. So perhaps you need to be doing "range lookup" as opposed to precise exact match? Just a hypothesis.
Apr 20 2020 10:14 AM
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()