Please give examples of the data you are using, the value you are using as a
key and the LOOKUP formula itself

Regards

Trevor


"Sonohal" wrote in message
...
Hello

I am trying to use VLOOKUP to find an exact match, the problem is that the
cell contains data that is a series of letters and numbers. I have used
vlookup to find and then return data successfully if the search cells are
all
letters OR all numbers, but can't get it to work when both are present. I
have also tried formatting the cells to read as 'text', or 'general',
neither
of which made a difference. PLEASE HELP! Thanks