Vlookup & exact match
OK - I got the "False" part, which is great. But I still want some kind of
error message to pop up to tell the user that the policy number they entered
was not found. "False" automatically enters the "#N/A" error message. Any
ideas?
"Munchkin" wrote:
In my worksheet/form a user enters a policy number in B5 to search for
details.
B6 holds the vlookup formula which displays their info.
But if a non-existing policy is entered in B5, B6 shows the next closest
match. How do I force an exact match & give some sort of error message when
an invalid # has been entered ? Thanks!
=VLOOKUP(B5,List2,2)
|