I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an error.
Unfortunately, the two cells that should not have data actually do have data and a "Link In from <unknown sheet>" (broken link/red arrow cell).
I am able to work around this, but was hoping to avoid another pull from one of the summary sheets with
- =INDEX({Range1}MATCH([Column A]1,{Range2},0))
