This is one option
=IF(ISERROR(MATCH(TRUE;ISNUMBER(FIND($D$3:$D$7;A3) );0));"";INDEX($E$3:$E$7;MATCH(TRUE;ISNUMBER(FIND( $D$3:$D$7;A3));0)))
Hope it helped
Ola Sandström
See encl zip-file:
http://www.excelforum.com/attachment...tid=3495&stc=1
+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3495 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=378998