Wildcard string
 

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

Wildcard string
 

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


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

Wildcard string
 

Thanks very much!!

Robo


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