lookup within a formular

[Grumpar]

Hi,
I am hopeing someone can help with this, I have numerous cels on worksheets that refer to a different workbook

='[Drivers_Invoices_2019.xlsm]Drv 1-3'!$D$59

I would like to have a a cel on a setup sheet in the workbook where I can put in a date that the above formula will look for. Example: I type in 2021 and the above formula will read ='[Drivers_Invoices_2021.xlsm]Drv 1-3'!$D$59 or if I type 2022 the formular will read ='[Drivers_Invoices_2022.xlsm]Drv 1-3'!$D$59

at the moment I have to go through the whole wokbook and change the year of the drivers_invoice workbook
Thanks
Grumpar

[AliGW]

Like this:

=INDIRECT("'[Drivers_Invoices_"&A1&".xlsm]Drv 1-3'!$D$59")

where A1 is the cell containing the year.

[Richard Buttrey]

Hi and welcome to the forum

Just use

Data...Edit Links...Change Source and select the 2021 workbook.

[Grumpar]

Thankyou AliGW for quickly responding, that worked great.
Thankyou Richard Buttrey, I will check that out too.

[AliGW]

Glad to help.