This problem is having me scratching my head. I am not sure if there is a solution as a search on internet does not come up with anything close to an answer. So hopefully someone out there can show me a way or say "give up - there is no way".
I have a IFERROR, INDEX, MATCH formula that finds and returns values from other workbooks. The other source workbooks are named Site01, Site02 and so on. The results are listed in a column so row 1 will return values from Site01, row 2 will return Site02 and so on. So in the formula it will refer to ..."Site01.xlsm" (twice).
Is there a formula (to place next to these results) that will search the said IFERROR, INDEX, MATCH formula and return the source workbook name i.e. Site01 , Site02 and so on? I am assuming there may be a generic way to search a given text in a formula or a specific way to return a workbook name.
Please note I am searching a formula not a text.
Any guidance is greatly appreciated.