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

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
Asked:
shane35007
1 Solution
 
SeanSystem 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
 
ButlerTechnologyCommented:
=IF(D8="X",$D$7,IF(E8="X",$E$7,IF(F8="X",$F$7,"NR")))

Open in new window

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
 
Patrick MatthewsCommented:
What happens at 50 and 75?  At present, your boundary conditions do not cover those two cases :)
0
 
shane35007Author 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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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