Maybe the value on one or other sheets has leading or trailing spaces.

Check them both out using =LEN(cell)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mortir" wrote in message
...
I have 2 sheets. In one i make calculations in other i have data
(DataSheet)

Id like to extract exact data from my data sheet. I have unique
identifiers in both sheets for the same items, so I tried to extract
data using vlookup:

=VLOOKUP(R3;'DataSheet'!1:22;7;FALSE)

in cell R3 is the unique id. (for example: ES0313860159) - and exactly
the same ID is in the 'DataSheet'

but then instead of getting the value from column 7 in DataSheet which
i was looking for i get the result N/V

whats wrong?