'How can I reference a cell from a different sheet in Excel, only if the sheet exists?
Basically, I need the cells that are being reference from a sheet that has been deleted to not show "!REF". Is this possible to do only using Excel?
Solution 1:[1]
Try the function indirect(), i use this function for myself for refer a sheet that is deleted and recreated.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | CGDPaul |