MATCH Multiple Columns

[mikeymay]

I am sure I've done this before but is there a way to find the row containing multiple matches?

E.g.
In the list below I want to find the first row where Col W contains 'Ledger' and Col X contains 'BTC'

The formula should return 4

TIA

 

[etaf]

try
=MATCH("Ledgar"&"BTC",W:W&X:X,0)

Book1
	W	X	Y	Z	AA	AB
1
2
3	Fred	Ada				4
4	ledgar	BTC
5	ledgar	BTC
6	ledgar	BTC
7	ledgar	BTC
8
9
Sheet1

Cell Formulas
Range	Formula
AB3	AB3	=MATCH("Ledgar"&"BTC",W:W&X:X,0)