Forum Discussion
Help with a process / formula(s) to look up variable values and return the data
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
Totally understand and thank you for your assistance so far. I've managed to remove some of the sensitive information from the attached Workbook, which is the one i wanted to use.
I would really appreciate if you could help by applying the same principals to this workbook.
Essentially, the months run from April to May and the analysis tab is call "Requester Summary".
Within the requester summary are tables which is where i need the data retrieved to. The data for each table is listed below,
- BHM Table - Should show information for requesters associated with the team "BHM". Should show the requester name, total requests and value of requests for authorised requests only.
- Contract Hub / Directorate table - Should show information for requesters associated with the team(s) "Contract Hub" or "Directorate". Should show the requester name, total requests and value of requests for authorised requests only.
- Neighbourhood Management & Community Protection table - Should show information for requesters associated with the team(s) "NHM" or "Community Protection". Should show the requester name, total requests and value of requests for authorised requests only.
- Parks, Leisure & Cemeteries Table - Should show information for requesters associated with the team "Parks", "Leisure" or "Cemeteries". Should show the requester name, total requests and value of requests for authorised requests only.
- Other Table - Should show information for requesters associated with the team "Other". Should show the requester name, total requests and value of requests for authorised requests only.
I hope the above makes sense ? Its in essence very similar to what you provided previously. Thanking you in advance for your time, help and patience on this !
Thanks
Raj
I think there was some kind of format problem with your sheet. I thought the show formula mode was turned on but it wasn't it. With your original file, if the problem is still there, you can copy the format (format painter) of the attached file. Once again, double check those attached formulas.
Bye
durendal Sorry to come back to you so late on this. I've been on leave !.
I've managed to overcome the formatting issue but i now have a Spill error :(. When i copy the formula from the spreadsheet you attached, the formula points to that file rather than the workbook i'm using. Even when i try and remove the previous file name, it doesn't work and gives me the spill error.
Attached is the spreadsheet i want to use and also shows the "Spill" error. I would be grateful if you could take a final look for me and help sort it out 😞
Thanks Raj