Hi,

Im trying to get value from cell
A1 from file name XXX.xlsx

The thing is that I hold name of this file in another cell.

I give an example:

File X.xlsx,
I want to get value from file Y from cell A1. (same folder)

formula:
=[Y.xlsx]Sheet1!A1

but the name I want to get from cell:
=[A1]Sheet1!A1

This way I get only string not value, the name of file is in cell A1 in string form.


I hope u get it.

Thanks for answer