LookUP certain words and return back corresponding values

[Excel Dumbo]

Hello friends,

please help build a formula to lookup certain values ina list of dat
and pull out corresponding values.

Please see attached.

Any help will be appreciated.


Regards,
Dumb

+-------------------------------------------------------------------
|Filename: LookUP certian words and return back values.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=865
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Fri, 3 May 2013 08:36:20 +0100 schrieb Excel Dumbo:

please help build a formula to lookup certain values ina list of data
and pull out corresponding values.

try in D2:
=IF(COUNT(SEARCH({"EYECARE PLUS","EYE CARE PLUS"},A2))+COUNT(SEARCH({"EYECARE PLUS","EYE CARE PLUS"},B2))>0,C2,0)


Regards
Claus Busch

 

[Excel Dumbo]

thanks claus. it worked like magic. thanks heap

+-------------------------------------------------------------------
+-------------------------------------------------------------------