Wildcard string

R

Robo

Can I use vlookup to find a wildcard text string

ie =vlookup(*a2*,data_range,2,false)

If not vlookup, is there an alternative?

Thanks

Robo
 
M

mdbct

You ned to concatenate your *s to the cell reference. Your formula would
be:
=vlookup("*"& A2 & "*", data_range,2,false)
 
Top