If your sheets are named "1", "2", rather than your example ("sheet5",
"sheet2"), one way:
=INDIRECT(MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+
1, 255)-3 & "!A3")
Note that the file has to be saved for that to work.
In article ,
Iolao wrote:
I have a list of several sheets, named with numbers (1,2,3,ecc.). I need
some kind of function that allows me to have the value of one cell equal
to that same cell in 1 to 3 sheets before. Example:
sheet5
A3= value of A3 in sheet2 (5-3)
How is that possible?
|