Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"Search" Function with answer prepared by Biff for Brantty on 01/0
Dear All,
I found the following beautiful formula from one question raised by Mr Brantty on 01/08/2005 and the answer is prepared by Mr Biff. =IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" ) I would like to apply the search by data field instead of specified data like "USDA". My search data involve more than 2 criteria and they change every time that it would be very troublesome to modify the formula every time. I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work. In my case I prefer not to use vlookup or VBA or macro in order to ease the users. Thanks Frances |
#2
|
|||
|
|||
Try...
=IF(OR(ISNUMBER(SEARCH($A$1:$A$2,C1))),1,"") ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Frances" wrote: Dear All, I found the following beautiful formula from one question raised by Mr Brantty on 01/08/2005 and the answer is prepared by Mr Biff. =IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" ) I would like to apply the search by data field instead of specified data like "USDA". My search data involve more than 2 criteria and they change every time that it would be very troublesome to modify the formula every time. I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work. In my case I prefer not to use vlookup or VBA or macro in order to ease the users. Thanks Frances |
#3
|
|||
|
|||
Domenic:
Thank you very very for your help. Frances "Domenic" wrote: Try... =IF(OR(ISNUMBER(SEARCH($A$1:$A$2,C1))),1,"") ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Frances" wrote: Dear All, I found the following beautiful formula from one question raised by Mr Brantty on 01/08/2005 and the answer is prepared by Mr Biff. =IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" ) I would like to apply the search by data field instead of specified data like "USDA". My search data involve more than 2 criteria and they change every time that it would be very troublesome to modify the formula every time. I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work. In my case I prefer not to use vlookup or VBA or macro in order to ease the users. Thanks Frances |
#4
|
|||
|
|||
Dear Domenic,
Thanks very much for your help with the formula below. How can I apply this formula to the conditional formatting as I want to highlight the data found? Frances "Domenic" wrote: Try... =IF(OR(ISNUMBER(SEARCH($A$1:$A$2,C1))),1,"") ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Frances" wrote: Dear All, I found the following beautiful formula from one question raised by Mr Brantty on 01/08/2005 and the answer is prepared by Mr Biff. =IF(OR(ISNUMBER(SEARCH({"USDA","GRADE"},C1))),1,"" ) I would like to apply the search by data field instead of specified data like "USDA". My search data involve more than 2 criteria and they change every time that it would be very troublesome to modify the formula every time. I tried =IF(OR(ISNUMBER(SEARCH({$A$1,$A$2},C1))),1,"") , but it does not work. In my case I prefer not to use vlookup or VBA or macro in order to ease the users. Thanks Frances |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Search function | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Search function using commas | Excel Worksheet Functions | |||
SEARCH function #VALUE! result | Excel Worksheet Functions | |||
HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions |