Go Premium for a chance to win a PS4. Enter to Win

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

Populate cell based on values in two other cells

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
zerog
Asked:
zerog
  • 2
  • 2
1 Solution
 
Rgonzo1971Commented:
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
 
zerogAuthor Commented:
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
 
Rgonzo1971Commented:
Hi,

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

Regards
Book2-SAMPLEv2.xls
0
 
zerogAuthor Commented:
Thank you
0

Featured Post

Industry Leaders: We Want Your Opinion!

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!

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