VLOOKUP not working properly some values not being caught by VLOOKUP

Copper Contributor

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.

 

 

2 Replies

@Jheeljp 

 

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.

@Jheeljp 

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()