Match Function Help

[newuser2015]

I'm using index and match for multiple criteria but my match formula isn't working.

For example, if I have two sheets with the following data assuming in columns A & B, how come this formula doesn't work and what is the proper formula
(MATCH(A1&B1,Sheet2!A1:A4&Sheet2!B1:B4,0)):

3, 200
1, 100
2, 300
4, 400

&

6, 200
7, 100
3, 200
4, 100

 

[Jonmo1]

Change that : between the ranges to an &
And enter the formula as an array by pressing CTRL + SHIFT + ENTER
=MATCH(A1&B1,Sheet2!A1:A4&Sheet2!B1:B4,0)