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
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!!
Ladkisson
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!!
Flyster