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.