Hi,

VLOOKUP supports wildcards, so if you replace $A3 with

"*"&$A3&"*"

you have "contains"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sarah (OGI)" wrote:

I've got the following formula:

=IF(VLOOKUP($A3,Lookup!$A:$K,9,FALSE))=16,"Yes","N o")

However, I'd like the formula to now see if the result of the vlookup
contains (not equals) a particular value, i.e. if the returned value contains
'16', I want to show "Yes", otherwise "No".

A vlookup might not even be the right function for this, so any help would
be appreciated.

Many thanks in advance.