Find the value when column and row is matched

[hongwei]

Hi, I want to find the value in sheet2.
For example,
when N:N in sheet 1 is matched with sheet2!2:2 and O:O in sheet 1 is matched with sheet2!G:G,
I want to get the value under the matched column and row. I meant the content in column and row are matched
Example, column matched is N, and row matched is 3, then I want to get the value in sheet2!N3.
Is it possible to do these series? Thanks for helping

 

[alansidman]

Show us sample data and expected mocked up solution. Use XL2BB to upload your samples. See my signature for instructions.

 

[hongwei]

Show us sample data and expected mocked up solution. Use XL2BB to upload your samples. See my signature for instructions.

I got something like this:
=INDEX(sheet2!$K$2:$S$25,MATCH(sheet1!$E11,sheet2!$K$2:K11,0),MATCH(sheet1!$G11,sheet2!K$2:S$2,0))
This formula got what I want.
But is it possible to add IF statement, where:
if nothing matched, do calculation $I2*J2

Thanks

 

[bebo021999]

Try:
=IFERROR(your_index,$I2*J2)

 

[hongwei]

Try:
=IFERROR(your_index,$I2*J2)

It works! Thanks a lot