Hi, the problem I have with lookup is that it doesn't do an exact match. It matches any part of Lookup_value with any part of Lookup_vector and returns the value.

I need it to bring the result_vector only if the Lookup_value is exactly the same as Lookup_vector. if its not exactly the same then put na or what ever it is it puts.

The code I am using is
=LOOKUP(A2,Sheet2!A2:A53,Sheet2!B2:B53)
and what happens is that it doesn't do an exact match, as long as a part of the Lookup_Value matches Lookup_vector it returns the Result_vector.

I tried using vlookup and hlookup but they where acting funny and I couldn't get them to work

Can some one please help me. Thank you.