Hello,

I need to find a way to do a Boolean search on a single row to see if specific text is present in any cells within that row. However, the row to search is dependent on the text in its first cell. Also, other than the first column of my table, all the other cells cannot be organized in any particular way because the traits to be listed in each are not regular in any way from row to row.

As an example, let’s say we have the following table:

Plates Red Ceramic
Bowls Wood Green Blue
Cups White Plastic


I want to be able to search the cups row to see if ‘White’ is present by just typing ‘cups’ in one cell (let’s say, cell B10) and ‘white’ in another cell (C10). The question is, what would my formula look like In my result cell for this?

So far, I’ve got:
=MATCH(B10,A:A,0) which gives me the right row to look (3 in this case)
-and-


=MATCH(C10,3:3,0) which would let me know if it sees ‘White’ or not

The issue is, I don’t know how to put the results of the first formula into the second argument of the second formula. I can’t manually type ‘3:3’. I need it to pull the ‘3’ result from the first formula and insert it into the second formula automatically. How can I do this, or is there another way I should be going about this problem?

Any help would be greatly appreciated.