Thread: LookUP certain words and return back corresponding values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default LookUP certain words and return back corresponding values
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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote