Map vertical values with horizontal values
Hi! I have "Test" and "Control" data. For each "test" I have 10 different "control" numbers. Pls refer to the "Control" tab in the attached file. In tab "A" I need to map column B that has "contol" data with Section D2-AK 1650. As of now I have it as hard coded values but would like to have it linked through a formula since column A tab A will change and will have a random order for "control" and "test". Hope this all makes sense. Thanks!
Mapping.xlsx
Mapping.xlsx
ASKER
I am home now w/t my laptop...so I can't really test out the pivot table option ( I have too many other computations based on the format that I included in the attached file) Meanwhile, could you think of a formula that would link the data the way I need? Thanks!!
ASKER
Hi, I took a closer look at your pivot table option and it is not what I had asked. Tab A is my target with a needed formula. Tab "Control" just gives an additional insight. I am still looking for an answer. Thank you!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Flyster
Mapping.xlsx