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


--
Robo
------------------------------------------------------------------------
Robo's Profile: http://www.excelforum.com/member.php...o&userid=12058
View this thread: http://www.excelforum.com/showthread...hreadid=487236