retrieve value from another tab/sheet when I know the column row

%3CLINGO-SUB%20id%3D%22lingo-sub-1604738%22%20slang%3D%22en-US%22%3Eretrieve%20value%20from%20another%20tab%2Fsheet%20when%20I%20know%20the%20column%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604738%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20photo.%3C%2FP%3E%3CP%3EI%20have%20the%20column%20and%20row%20number.%20What%20is%20the%20syntax%20%2F%20formula%20to%20retrieve%20the%20value%20contained%20in%3CBR%20%2F%3E!4_Mstr!BD7%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebd%20is%20column%2056%20and%207%20is%20the%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20get%20a%20spill%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604862%22%20slang%3D%22en-US%22%3ERe%3A%20retrieve%20value%20from%20another%20tab%2Fsheet%20when%20I%20know%20the%20column%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F573812%22%20target%3D%22_blank%22%3E%40Diviner_Gregg%3C%2FA%3E%26nbsp%3B%20Wow%20that%20picture%20is%20busy%20but%20I%20believe%20the%20function%20you%20want%20is%20INDIRECT()%26nbsp%3B%20and%20to%20select%20FALSE%20for%20the%20cell%20reference%20type%20as%20follows%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDIRECT(%22r%22%26amp%3B'4_Mstr'!EF58%26amp%3B%22c%22%26amp%3B'4_Mstr'!ED58%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eso%20inside%20it%20builds%20the%20text%20to%20say%20the%20cell%20reference%20you%20want%20in%20the%20format%20r3c8%20but%20instead%20of%20the%20numbers%20you%20want%20the%20'4_Mastr'!EF58%20cell%20reference.%26nbsp%3B%20I%20may%20have%20those%20cells%20backward%20but%20I%20hope%20you%20get%20the%20idea.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

@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.