Formula looking at column information
I have a vlookup formula pulling in information from another sheet into a Pivot Table.
In the Utilization column I need the breakdown from the columns to the right that match the categories in the Nominated to: column.
Which if it's one category I have a formula that's working,
=[Nominated to:]@row + " - " + [Sports Med - Event Count]2
but it's taking time to build them all out and in most cases there is more than 1 category in the Nominated to: column
I reached out to support and they gave the following solution, but it's pulling the Grand Totals column number and assigning it to both Nominated to: categories
- =SUBSTITUTE([Nominated To:]@row, CHAR(10), " - " + [Grand Totals]@row + ", ") + " - " + [Grand Totals]@row
But, it may be split - what I'd like is for the Utilization column to look at all the columns to the right and then report the actuals where there is information with that matches the Category from the Nominated to: column and the Number from the corresponding column.
What I'd like this to look like is this:
Any assistance on if this is possible and how to achieve it would be appreciated!
Help Article Resources
Check out the Formula Handbook template!