Hi

Use vlookup(lookup value, table array, index number, 0)

The zero returns a false value which means it has to be an
exact match.

Ed


-----Original Message-----
Hi...

I need a vlookup formula/code that will return an EXACT
value or an error message telling the user that the
number
they've enetered doesn't exist...

Help in any form welcome!

GC
.