Useing (='sheet'!cell) if the sheet name is depending on cell
Closed
Hello,
how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3
='sheet1'!C3 is working, but the sheet name is depending on A2
i got an error if i type (='A2'!C3) is there another way for it?
thank you
how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3
='sheet1'!C3 is working, but the sheet name is depending on A2
i got an error if i type (='A2'!C3) is there another way for it?
thank you
Related:
- Useing (='sheet'!cell) if the sheet name is depending on cell
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide