Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LookUP certain words and return back corresponding values
Hello friends,
please help build a formula to lookup certain values ina list of data and pull out corresponding values. Please see attached. Any help will be appreciated. Regards, Dumbo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
thanks claus. it worked like magic. thanks heaps
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup 2 values to return 1 | Excel Worksheet Functions | |||
lookup to bring back multiple values | Excel Worksheet Functions | |||
Lookup 2 values and return a third | Excel Worksheet Functions | |||
How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |