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


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.   






Hope this helps.



best response confirmed by wanalearn (Occasional Contributor)

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


Thank you,