M
Munchkin
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)
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)