Aug 21 2020 03:05 PM
See photo.
I have the column and row number. What is the syntax / formula to retrieve the value contained in
!4_Mstr!BD7 .
bd is column 56 and 7 is the row.
I get a spill error.
Thanks.
Aug 21 2020 04:12 PM
@Diviner_Gregg Wow that picture is busy but I believe the function you want is INDIRECT() and to select FALSE for the cell reference type as follows:
=INDIRECT("r"&'4_Mstr'!EF58&"c"&'4_Mstr'!ED58,FALSE)
so inside it builds the text to say the cell reference you want in the format r3c8 but instead of the numbers you want the '4_Mastr'!EF58 cell reference. I may have those cells backward but I hope you get the idea.