SOLVED

Please help me with this

Occasional Contributor

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 Replies

@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

best response confirmed by wanalearn (Occasional Contributor)
Solution

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

 

Thank you,

Dexter