vlookup not working properly

[bigdan]

I'm comparing two massive sets of data. I'd like to do a vlookup but in the few numbers that I have matched the vlookup doesnt work.

I found this number in both data sets: $245,712. This can be expanded to 245,711.55 or even 245,711.5500 etc. And they're both currency numbers. Not sure where the problem's coming from but is there an easy way to fix this so that I can do a vlookup on all numbers?

 

[oldbrewer]

I'm comparing two massive sets of data. I'd like to do a vlookup but in the few numbers that I have matched the vlookup doesnt work.

I found this number in both data sets: $245,712. This can be expanded to 245,711.55 or even 245,711.5500 etc. And they're both currency numbers. Not sure where the problem's coming from but is there an easy way to fix this so that I can do a vlookup on all numbers?

first column of lookup table must be ascending or descending order

you can get round this by using offset match instead

 

[63falcondude]

first column of lookup table must be ascending or descending order

you can get round this by using offset match instead

Would INDEX MATCH have this issue with order as well?

 

[bigdan]

first column of lookup table must be ascending or descending order

you can get round this by using offset match instead

why would that make a diff? i've often used vlookups on data that isnt in any specific order.