Hi, I am trying to return a result depending on a drop down list (in google sheets/excel).

Hi, I am trying to return a result depending on a drop down list (in google sheets).'

For instance, here's the values in the drop down list:
Standard Class Imprint = .281
Standard Class Live Stamp = .281
First Class Imprint Letter = .455
First Class Indicia = .455
First Class Imprint Card = .284
Standard Class Indicia .281

I have been trying something like =IF(OR(C6="Standard Class Imprint",C6="First Class Imprint Card"),".281",".284") etc etc, but I cannot get it to work, it either errors out, or only chooses the first result.
Maddison LakeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
this should work well:

=IF(OR(C6="Standard Class Imprint",C6="Standard Class Live Stamp",C6="Standard Class Indicia"),".281",IF(OR(C6="First Class Imprint Letter",C6="First Class Indicia"),".455",IF(C6="First Class Imprint Card",".284", "")))

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Maddison LakeAuthor Commented:
Thanks Ryan! Worked like a charm!
0
Rob HensonFinance AnalystCommented:
Maybe shorter:

=INDEX({0.281;0.281;0.455;0.455;0.284;0.281},MATCH(C6,{"Standard Class Imprint";"Standard Class Live Stamp";"First Class Imprint Letter";"First Class Indicia";"First Class Imprint Card";"Standard Class Indicia"},0))

Alternatively:

=INDEX($I$4:$I$9,MATCH(C6,$H$4:$H$9,0))

Where I4:I9 is list of values (0.281 etc) and H4:H9 is list of descriptions (Standard Class etc).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.