Forum Discussion
Help with a process / formula(s) to look up variable values and return the data
In the attached version, I have also added a pivot table as an alternative.
Thank you for previously supplying me with a solution to my problem. I'm wondering if you could help me tweak the formula based on the attached workbook.
Essentially i want to solve the same issue as previously highlighted although this time i want to be able to group by teams and the array needs to cover multiple months.
For example, In the analysis sheet, there are 4 teams. Essentially i want the formula to look across the 3 months, and populate a list of unique requesters, the no of requests and total amount spent against their team in the analysis tab.
Hope that makes sense ?
Thanking you in advance for you help.
Raj
I think this will do the trick; please check manually once that the answers here are correct. Don't hesitate if you need any explanation.
Bye!
i'm sorry to be a pain. I took the formula you provided and tried to transpose on to another spreadsheet but it's not accept it. See attached.
The problem i have is i can't share the actual spreadsheet i need to apply this to as it contains sensitive informaiton and i would be breaking Daat protection rules etc.
So i mocked up something similar and was going to copy the formula over to the real spreadsheet. But it's not working as it should 😞
Any help / advice would be welcomed.
Thanks
Raj
Your tabs seems to be names differently on your screenshot. The "April:December!$F$2:$F$100000" part of the formula says to take the $F$2:$F$100000 cells from the tab April to the tab December, with every tabs in between. Maybe the problem comes from this?
The VSTACK formula stacks the data vertically. I'm not so sure how to help you more than this without a lookalike file.
Bye
- Thank you as always 🙂
