Please help me with this

[wanalearn]

see attached

I am trying to get the matching value from the table in sheet 2 (it works like a times table from B to R and from 2 to 97) into sheet1 cell n4 based on cell j1 and cell M4

[#2]

@wanalearn 

You were likely having challenges because the value in M4 is an actual number, whereas the values on Sheet 2 in column A are entered as text.   Using &"" in the formula below directly after "Sheet1!M4" forces the number in M4 to be treated as text.   

=INDEX(Sheet2!$B$2:$R$87,MATCH(Sheet1!M4&"",Sheet2!$A$2:$A$87,0),MATCH(Sheet1!J1,Sheet2!$B$1:$R$1,0))

Hope this helps.

Dexter

[#3 · Accepted solution]

@wanalearn Please consider marking my answer if this works, otherwise, please provide additional detail.  

Thank you,

Dexter