You could enter this in C1 and copy down:
=ISNUMBER(SEARCH($A$1,B1))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"frosterrj" wrote in message
...
Oh, and the col a is actually a range as well, if that matters...
Thanks,
Robert
"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
|