Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

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
0
Ladkisson
Asked:
Ladkisson
  • 2
  • 2
1 Solution
 
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
 
FlysterCommented:
See Sheet2 of attached file. It uses an If statement with Sumproduct to lookup the values
Mapping.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now