[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

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

Posted on 2013-11-25
Medium Priority
212 Views
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
Question by:shane35007
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 11

Expert Comment

ID: 39676011
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

LVL 6

Accepted Solution

ButlerTechnology earned 2000 total points
ID: 39676176
``````=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

LVL 93

Expert Comment

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

Author Closing Comment

ID: 39677953
Fantastic formula.  Thank you so much.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micrâ€¦
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.
###### Suggested Courses
Course of the Month12 days, 15 hours left to enroll