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

Perhaps try the INDIRECT function ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, I tried.

Could you give me an example ?

I would like to add that the file is closed.