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
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
-Modified-
at D2,CTRL + SHIFT + ENTERPlease Login or Register to view this content.
drag down.your A5 no full filled the search EYECARE, there is a space.
Last edited by wenqq3; 05-03-2013 at 03:55 AM.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
hi Joseph. maybe:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH({"eyecare plus";"eye care plus"},A2:B2)))),C2,0)
this could work too, but might be a bit risky:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH({"eye*care plus"},A2:B2)))),C2,0)
something like "Badeye Inspector Care plus" would be counted
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
thanks a lot Benishriyo.....both the formula worked like magic. however i'll take note of the comment for the second formula. thanks heaps
thanks wengq, it works well when "EYECARE PLUS" is present, but it is not working when there is space between eye and care
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks