Row Number with Match with two criteria

[asolopreneur]

I want to know the row number matching two values in two columns.

SHEET 1 ↓↓↓↓

COLUMN 1	COLUMN 2	COLUMN 3
A	1
B	2
B	1

SHEET 2 ↓↓↓↓

COLUMN 1	COLUMN 2	COLUMN 3
A	1	I want the row number HERE from sheet1
B	1	Here result should be 3

Do you know any formula which I can use in Google sheets to get the row number matching two values in two columns.

thanks in advance.

 

[maabadi]

Please update account details to we can update better based excel version.
Try this at sheet2:

Book1
	A	B	C	D	E
1	A	1		1
2	B	1		3
3
4
5
Sheet2

Cell Formulas
Range	Formula
D1:D2	D1	=MATCH(1, INDEX((Sheet1!$A$1:$A$100=A1)*(Sheet1!$B$1:$B$100=B1),0,0),0)

 

[asolopreneur]

Please update account details to we can update better based excel version.
Try this at sheet2:

Book1
	A	B	C	D	E
1	A	1		1
2	B	1		3
3
4
5
Sheet2

Cell Formulas
Range	Formula
D1:D2	D1	=MATCH(1, INDEX((Sheet1!$A$1:$A$100=A1)*(Sheet1!$B$1:$B$100=B1),0,0),0)

Thanks a lot, saved my day.

 

[maabadi]

You're Welcome & thanks for follow-up.
Please Update account details. (link exist at below of my post).

 

[Fluff]

Do you know any formula which I can use in Google sheets

In future when asking about Google Sheets, please post you question in the General Discussion & Other Applications section of the board.
Thanks