Vlookup and Hlookup have an optional fourth argument,
RangeLookup. It defaults to TRUE, which means, for
example, that if you have a lookup table:

1 One
2 Two
3 Three

and you lookup on 1.5, it will return One.

Set it to FALSE and it will only use an exact match.

HTH

-----Original Message-----
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.

Can some one please help me. Thank you.
.