• Status: Solved
• Priority: Medium
• Security: Public
• Views: 235

# Excel help needed...populate a cell based on mark in another cell

I have an excel spreadsheet that has three cells titled as follows
Poor <50.0
Avg >50.0<75.0
Excellent >75.0

These are in cell D7, E7 and F7, respectively.

If I place an X in any of the cells below those (i.e. D8, E10, F 12)

I'd like to have that cell D7 wording placed in a rating cell, i.e. H8.

Can I do this?  How can I do this?
0
shane35007
1 Solution

System EngineerCommented:
The only way i can think of doing this is to have two tabs with identical tables. Then in your first tab you would need to do an if statement. I.E. =IF(Sheet2!A2="x",Sheet2!A1," ") This would fill in your table automatically for you with the wording you want. I attached the spreadsheet i made as an example
Book1.xlsx
0

Commented:
``````=IF(D8="X",\$D\$7,IF(E8="X",\$E\$7,IF(F8="X",\$F\$7,"NR")))
``````
The above formula in cell H8 should do the trick.  It uses absolute referencing, so it will easily copy.  The cell will show NR if you have not select a column or you have not used an X.
Tom
0

Commented:
What happens at 50 and 75?  At present, your boundary conditions do not cover those two cases :)
0

Author Commented:
Fantastic formula.  Thank you so much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.