Forum Discussion
Solved
Please help me with this
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
wanalearn Please consider marking my answer if this works, otherwise, please provide additional detail.
Thank you,
Dexter
2 Replies
wanalearn Please consider marking my answer if this works, otherwise, please provide additional detail.
Thank you,
Dexter
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