This is my data:
R1 A x
R2 A y
R3 A z
R4 B x
R5 B y
R6 B z
The letters A and B are in Column G, and the x y z are in Column H. I want to figure out the row that contains both the letters B and y. Not just B or y, but B AND y.
Assume that "B" is in Cell A1 and "y" is in Cell A2.
I tried this:
=MATCH(1,(A1=G1:G6)*(A2=H1:H6),0)
I should get "5" as an output, but I just get "#VALUE!"
I also tried this:
=MATCH(A1&A2,G1:G6&H1:H6,0)
Still just get "#VALUE!"
I also tried this:
=MATCH(A1,(If(H1:H6, G1:G6),0)
Still fail.
Lastly, how do you post these excel questions on here without the html code. I can't create the table with the html code.
Bookmarks