I have been using the function:

=LOOKUP(B10,ListSheet!$C$2:$C$29763,ListSheet!$D$2:$D$29763)

To lookup corresponding values.

But the problems with "LOOKUP" function are:

a. It does not always do an exact match.

b. It finds the nearest match which is not always the correct answer.

c. The "$C$2:$C$29763" list needs to be sorted.

So how can I do a lookup where:

1. Only the exact match returns a result.

2. Actually, the first exact match returns a result. There will be duplicates in the "$C$2:$C$29763" list.

3. If there is no exact match then it should return some error/warning message.

4. The "$C$2:$C$29763" list does not need to be sorted.

Is there some other fuction which will do this?

Thanks.