: "I've been struggling for the past few days with creating a dashboard in a separate tab of my resource planner. The planner has employee names listed in column A, and their data is spread over two rows per person. I need to fetch a percentage figure related to a specific employee and week number, as shown in the highlighted area of my resource test data. I'm unsure which function or combination of functions (lookup, match, index, filter) to use for this task. For instance, if I select 'Employee2' and 'Wk48', it should return 'Capacity taken: 63%'. Which formulas or methods would allow me to dynamically filter and display this data?",
The prompt asks for the string 'Capacity taken:'. But the answer just has the pct.
it should return 'Capacity taken: 63%'.
: "I've been struggling for the past few days with creating a dashboard in a separate tab of my resource planner. The planner has employee names listed in column A, and their data is spread over two rows per person. I need to fetch a percentage figure related to a specific employee and week number, as shown in the highlighted area of my resource test data. I'm unsure which function or combination of functions (lookup, match, index, filter) to use for this task. For instance, if I select 'Employee2' and 'Wk48', it should return 'Capacity taken: 63%'. Which formulas or methods would allow me to dynamically filter and display this data?",The prompt asks for the string 'Capacity taken:'. But the answer just has the pct.
it should return 'Capacity taken: 63%'.