cpatomba18
New Member
- Joined
- Feb 3, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am trying to retrieve data from a single data tab and output it to a summary tab.
The summary tab has two drop down validations. The 1st is to retrieve the name of the city. The 2nd is to retrieve the name of the division.
On my data tab, I have two columns - 1st is the city name and 2nd is the division name. I also have two header rows - 1st header row is Year and 2nd header row is Quarter.
My output on the summary tab needs to have the quarter of the calendar year in the column and the year in the row. Right now I am trying a combination of INDEX/MATCH/CONCATENATE as an array function and getting "N/As".
Wondering if this is because my structure in my data set is different from how I want the output?
The summary tab has two drop down validations. The 1st is to retrieve the name of the city. The 2nd is to retrieve the name of the division.
On my data tab, I have two columns - 1st is the city name and 2nd is the division name. I also have two header rows - 1st header row is Year and 2nd header row is Quarter.
My output on the summary tab needs to have the quarter of the calendar year in the column and the year in the row. Right now I am trying a combination of INDEX/MATCH/CONCATENATE as an array function and getting "N/As".
Wondering if this is because my structure in my data set is different from how I want the output?