How to get one of three options in a cell based on a drop down selection in another cell

**Alaw14** · 01-21-2015, 11:18 AM

I am hoping someone can help me. I have a drop down box in cell d4 with 3 options. Based on the selection of one of those 3 I need cell e4 to populate with a specific text. For example if in d4 the user selects "Beginner <90 days" then I need e4 to populate with $20/hr. But if the user selects "Trained >90 days" in d4 then I need "$30/hr" to populate in e4. Or if user selects "Professional" in d4 then I need e4 to populate with "$35/hr". I thought I had a formula from a previous question but it says I have too many arguments. Can anyone advise?

**Special-K** · 01-21-2015, 11:26 AM

Try

=LOOKUP(D4,{"Beginner <90 days","Professional","Trained >90 days"},{"$20",""$30","$35"})&"/hr"

Note LOOKUP needs arguments in first set of brackets {} to be sorted hence Beginner Professional Trained.

Or

IF(D4="Beginner <90 days","$20",IF(D4="Trained >90 days","$30",IF(D4="Professional","$35")))&"/hr"

How to get one of three options in a cell based on a drop down selection in another cell

LinkBack

Thread Tools

Rate This Thread

Display

How to get one of three options in a cell based on a drop down selection in another cell

Re: How to get one of three options in a cell based on a drop down selection in another ce

Thread Information

Users Browsing this Thread

Similar Threads

Auto-fill a cell based on a drop down selection in one cell & a formula in another cell

Populating a cell based on drop down selection

Auto Fill a cell based on drop down selection in a another cell

Excel 2007 : Change a drop down options in one cell based on the selection of another cell

Change a Cell value based on drop down selection of another cell

Bookmarks

Bookmarks

Posting Permissions