Lookup problem

[Guest]

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.

 

[Frank Kabel]

Hi
if you use VLOOKUP you have to specify the 4th parameter
for an exact match. e.g.
=VLOOKUP(value,range,col_index, fALSE)
If this is not your problem you may post your used formula

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

 

[Helen Trim]

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.