You've gotten good counsel- Shane's method of doing wildcard matches
will work if the VLookup leftmost column of the lookup table array is
text or numbers stored as text, and if the col index number is 1. I'll
keep that trick in my back pocket...

Biff's use of Count to deal with the fact that FIND will generate an
error if it doesn't find the string is neat - I'd always used the
ISERROR() function to catch that condition, so I'll remember that, too.

One thing no one has mentioned - which may not apply - is to be
cautious if you are dealing with values other than integers -
15.9999999999 will look like 16 in any rationally formatted cell, but
will generate an apparent error because the formula will evaluate to No.
On the other hand, 1783.34916 will evaluate to "yes" when you might not
expect it to. If you are pulling data in from some other source or
depending on user input, the use of the ROUND function might be
appropriate...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111753