Forum Discussion
Cell referencing between tabs whilst filtering table
I have been cell referencing between 2 tabs on the same worksheet to carry data across from 'Invoiced' to an 'Overview' page to see budget comparisons on an install project. However, I have notic...
As you have suggested, the formulation that might interest you is probably an INDEX/MATCH or similar.
Can you attach a sample document without sensitive data or upload additional screenshots of the "Invoiced" tab as well as explain what is the desired output from the formulation?
I feel it would be easy to help with this problem in that way!