Munchkin,

try using this,

=IF(ISERROR(VLOOKUP(C8,A8:A12,1,FALSE))=TRUE,"No
Match",VLOOKUP(C8,A8:A12,1,FALSE))


Value list is from A8 to A12 and you are matching values in C8.


--
Sheikh Saadi


"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)