Multiple IF ISNUMBER SEARCH

Hello, i am posting first time, so i hope i am doing it correctly in the right forum. I found one thread about multiple IF IS NUMBER SEARCH problem but it didnt solve my problem, thats why i am posting this

I have a three columns A, B and C
in a column A is text, it can be three different words like "high" or "low" or "centre"
in a column B is a text too, it can be three different words too like "under" or "above" or "cross"
In a column C is a number

I want to use multiple IF ISNUMBER SEARCH formula but i dont know how to do it.

I want excel to check column A if it contains text "high" and check column B if it contains text "under" and then return value from the column C into the column D (shortly if A and B matching my criteria excel returns C into D. And D is a result column for my criteria. I may have more criteria colums like this, in this case i will have 9 colums (because three different words in A x three different words in B = 9 combinations of words, thats for explanation only)

I know how to do it with excel checking columns A without column B
Here is an example:

D1=IF(ISNUMBER(SEARCH("high",A1)),C1,"")

but i dont know how to do it with multiple cells ( A and B in this case)

The reason i want to use function IF ISNUMBER SEARCH is that, that columns A and B may contain more than just a word " high","low" or "centre" and i want excel to search within the text in these columns. Thats why i can not use formula D =IF(AND(A="high",B="under"),C,"")

Any ideas how to combine IF ISNUMBER SEARCH formula , let me know please

p.s., sorry for my english, i am not a native speaker, just learning

Thank you

You already know the solution is an AND() construct, one test for each cell.

=IF(AND(ISNUMBER(SEARCH("high",A1)), ISNUMBER(SEARCH("under",B1))), C1, "")

Another way would be to use COUNTIF with wildcards, e.g.

=IF(COUNTIF(A1,"*high*")*COUNTIF(B1,"*under*"),C1,"")

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.