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

Try this:

=IF(COUNT(FIND(16,VLOOKUP($A3,Lookup!$A:$K,9,0))), "Yes","No")


--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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.