zerog
asked on
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
Book2-SAMPLE.xls
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
pls try
Open in new window
Regards
Book2-SAMPLEv1.xls