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
LadkissonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
FlysterConnect With a Mentor Commented:
See Sheet2 of attached file. It uses an If statement with Sumproduct to lookup the values
Mapping.xlsx
0
 
FlysterCommented:
You can try a pivot table. See Sheet1 of attached

Flyster
Mapping.xlsx
0
 
LadkissonAuthor Commented:
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!!
0
 
LadkissonAuthor Commented:
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!!
0
All Courses

From novice to tech pro — start learning today.