Ask Your Question

Revision history [back]

Yes, you can do that:

=INDIRECT("'./material costs.ods'#$Webbing.$C$2:$C$6")

I guess another use case for this would be sending projects with more than one spreadsheet to other people without broken references.

(If this works for you, please click on the ✓ to accept the answer.)