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.
RajI 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
- Thank you Hans, appreciate it.
