Return the row number of two MATCHES

Hello,

I'm trying to find the row number of two matches. I know how to return the row number of, for example, the white car (MATCH("White",B2:B5,0)).

But would like to return the row number of the Black Golf.



match.PNG

Can anyone help?

Thankyou.

Your request example, the white car (MATCH("White",B2:B5,0)),But would like to return the row number of the Black Golf.
Pls try this array formula
D6 cell

HTML Code: 

Originally Posted by AliGW

Try this (untested):

=LOOKUP(2,1/((A2:A5="Golf")*(B2:B5="Black")),ROW(B2:B5))

Thank you AliGW - that seems to have sorted it!

Originally Posted by AndyRob1973

Thank you AliGW - that seems to have sorted it!

Thankyou wk9128, I don't seem to be able to get that to work. I suspect I'm doing something wrong.

Originally Posted by wk9128

Your request example, the white car (MATCH("White",B2:B5,0)),But would like to return the row number of the Black Golf.
Pls try this array formula
D6 cell

HTML Code: 

Thankyou wk9128, I don't seem to be able to get that to work. I suspect I'm doing something wrong.

Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly

Array formula , To enter as an array formula instead of pressing ENTER, you press CTRL + Shift + Enter at the same time. You should see curly braces {} if it's entered correctly.
{=MATCH("Black"&"Golf",B2:B5&A2:A5,)+1}