Cell address issue

[trev1234]

Hi,
can someone please help me with the below formula, I am after just the cell reference but the result also brings through the name of the workbook and worksheet, any help would be great

=CELL("address",INDEX(INDIRECT("'" &$A2&"'!f2:z10"),MATCH($C2,INDIRECT("'" & $A2 & "'!e2:e10"),0),MATCH($D2,INDIRECT("'" & $A2 & "'!f1:z1"),0)))

result
'[Copy of Absence Spreadsheet (002).xlsm]January'!$V$4

thanks
trev

 

[trev1234]

found the answer

=TRIM(RIGHT(SUBSTITUTE(CELL("address",INDEX(INDIRECT("'" &$A2&"'!f2:z10"),MATCH($C2,INDIRECT("'" & $A2 & "'!e2:e10"),0),MATCH($D2,INDIRECT("'" & $A2 & "'!f1:z1"),0))),"$",REPT(" ",100),1),100))