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