Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
2 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Map vertical values with horizontal values
Posted on 2012-12-28
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
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!!
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!!
Active 1 day ago
See Sheet2 of attached file. It uses an If statement with Sumproduct to lookup the values
Mapping.xlsx
Mapping.xlsx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month2 days, 14 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.