Hi All,
I have the following search formula in Cell F1, which works great and enters "A1"value if true and "blank" if false.
However when i change the "within text" to look at more cells in the same row, the formula doesn't work. See example below:
Couple notes: Im using cell G1 as a linked cell from a combo box, so im able to type in a keyword for filtering. I want to be able to type multiple words for a more refined filter, and if all the words match, then returns value of cell "A1" (which is just a row number).
Example:
<tbody>
</tbody>
This is what i need the formula to be in words:
Cell F1=Search cells B1 thru E1, using the keyword/s in Cell G1, and if they contain the keyword or words, then return A1, otherwise a blank.
Also i would like it to not matter what order i type it in, or Uppercase/lowercase,or even a space, just as long as it contains the letters/numbers in the keyword cell, for example the following searches need to return A1 into F1:
the
thedog
the dog
dog the
etc....
I have the following search formula in Cell F1, which works great and enters "A1"value if true and "blank" if false.
Code:
=IF(ISNUMBER(SEARCH(G1,B1)),A1,"")
Code:
=IF(ISNUMBER(SEARCH(G1,[COLOR=#ff0000]B1:E1[/COLOR])),A1,"")
Example:
A | B | C | D | E | F | G | |
1 | 1 | The | dog | likes | me | input formula here | Linked cell from combobox for keyword/s |
2 |
<tbody>
</tbody>
This is what i need the formula to be in words:
Cell F1=Search cells B1 thru E1, using the keyword/s in Cell G1, and if they contain the keyword or words, then return A1, otherwise a blank.
Also i would like it to not matter what order i type it in, or Uppercase/lowercase,or even a space, just as long as it contains the letters/numbers in the keyword cell, for example the following searches need to return A1 into F1:
the
thedog
the dog
dog the
etc....