vlookup returning wrong data

[xcelwannabee]

If the item in the vlookup table Array does not exist, the vlookup returns the result of an unrelated item.

Is their another formula I can use?

[daddylonglegs]

What formula are you using?

Sounds like you have omitted the final argument, or set it to 1 or TRUE. For exact matches in an unsorted range you should have the final argument set to zero or FALSE, i.e.

=VLOOKUP(A1,B1:C10,2,FALSE)

[xcelwannabee]

Bingo....

That's it.

Thanks