Sep 07 2022 03:58 PM
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
Sep 07 2022 05:29 PM
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
Sep 10 2022 12:43 AM - edited Sep 10 2022 12:44 AM
Solution@wanalearn Please consider marking my answer if this works, otherwise, please provide additional detail.
Thank you,
Dexter
Sep 10 2022 12:43 AM - edited Sep 10 2022 12:44 AM
Solution@wanalearn Please consider marking my answer if this works, otherwise, please provide additional detail.
Thank you,
Dexter