Excel: Dynamic referencing

SamC 0
Viewed 16

I'm struggling with this formula

="'[workbook.xlsx]"&INDIRECT(B1)&"'!"&$C$5

B1 is a date: 05-09-22 and is also the name of a sheet in workbook.xlsx

What am I doing wrong?

Thanx for looking, Sam

reference dynamic excel
1 Answers

Try below formula.

=INDIRECT("'[workbook.xlsm]" & B1 &"'!$C$5")
Harun24hr0
Related