We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
12 days, 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 2 days 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 code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Suggested Courses
Course of the Month12 days, left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.