Solved

Populate cell based on values in two other cells

Posted on 2014-03-12
4
1,342 Views
Last Modified: 2014-03-13
Hello. I need to populate a cell based on values in two other cells. For example: In the attached file, in the first row of Sheet 1 I have a value filled in for Option 2 and for Level 3. I need cell M2 to be populated with the corresponding text for Option 2 Level 3 from Sheet 2. What would be the best way to do this? Any ideas how to start? Thanks
Book2-SAMPLE.xls
0
Comment
Question by:zerog
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
Hi,

pls try

=VLOOKUP(INDEX(B1:G1,1,MATCH(99999999,B2:G2),1),Sheet2!A1:E7,MATCH(99999999,I2:L2)+1,1)

Open in new window


Regards
Book2-SAMPLEv1.xls
0
 

Author Comment

by:zerog
Comment Utility
Perfect. This works great. Is there any way I can force the text to wrap in cell M2 in case some of the text is more than a line. Tried setting the cells to Wrap text but it doesn't work
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

it works but the line height will staay as the maimum used

Regards
Book2-SAMPLEv2.xls
0
 

Author Comment

by:zerog
Comment Utility
Thank you
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now