=vlookup("*" & a1 & "*", b1:b100,1,false)
will return "Many pizzas"
and
=not(iserror(vlookup("*" & a1 & "*", b1:b100,1,false)))
will return true/false

But even simpler:
=isnumber(match("*" & a1 & "*",b1:b100,0))
will return true/false



frosterrj wrote:

Is it possible to use the vlookup function when what you are trying to match
is a substring (partial match) of the table-array?

For example:
col a col b
1 pizza Many pizzas

I want to return a "true" when I do vlookup(a1, b1:b100,1,false), but I dont
know which function to use or where to get the lookup to find the text string
in a1.

Thanks,
Robert

--

Dave Peterson