Hi,
I have tried and failed to resolve the following:
I have a spreadsheet with 31 tabs,
30 have exactly the same structure and are named page-1, (...), page-30
1 is a summary tab and is named "report project summary".
In cell E7 of the summary tab, I want the following function:
- Check in cell C7 of every tab for the value in cell C7 of the summary tab (it will be a text value)
- If/when you find it, return the value in cell E7 of the corresponding tab (it will be a numerical value).
Further info:
- The value in cell C7 of the summary tab will never appear in two tabs. Once it has found it, it can stop looking
Bookmarks