What Function To Use With Multiple Values

I am trying to make a sheet that allows me to select an item (product) from a dropdown menu and then auto-populates a unit price for that specific product. I have 16 different products listed and different prices for each product. I have tried the =IF(CONTAINS() function and =IF(OR() function. The =IF(OR() function worked until I got past two different prices and then it gave me an "INCORRECT ARGUMENT SET" error message.


=IF(OR(Description@row = "100 - Ambrosia Apple (1)", Description@row = "101 - Mt Everest Crab Apple (1)", Description@row = "102 - Coral Champagne Cherry (1)", Description@row = "103 - Chelan Cherry (1)", Description@row = "104 - Duarte Plum (1)", Description@row = "105 - Red Gold Nectarine (1)"), "25", IF(OR(Description@row = "106 - Mt. Huckleberry (2)", Description@row = "107 - Taper Leaf Penstemon (2)", Description@row = "108 - Showy Milkweed (2)", Description@row = "109 - Purple Coneflower (2)", Description@row = "110 - Woods Rose (2)", Description@row = "111 - Shaggy Fleabane (2)"), "10", IF(OR(Description@row = "112 - Quaking Aspen (5)", Description@row = "114 - Ponderosa Pine (10)"), "20", IF(Description@row = "113 - Western Larch (5)"), "12", IF(Description@row = "115 - Coffee Burlap bags (1)"), "2", IF(Description@row = "116 - Tree tubes (1)"), "1.75")))

The =IF() function gave me the "UNPARSEABLE" message.

=IF([Description]@row = "100 - Ambrosia Apple (1)", [Description]@row = "101 - Mt Everest Crab Apple (1)", [Description]@row = "102 - Coral Champagne Cherry (1)", [Description]@row = "103 - Chelan Cherry (1)", [Description]@row = "104 - Duarte Plum (1)", [Description]@row = "105 - Red Gold Nectarine (1)", "25"), IF([Description]@row = "106 - Mt. Huckleberry (2)", [Description]@row = "107 - Taper Leaf Penstemon (2)", [Description]@row = "108 - Showy Milkweed (2)", [Description]@row = "109 - Purple Coneflower (2)", [Description]@row = "110 - Woods Rose (2)", [Description]@row = "111 - Shaggy Fleabane (2)", "10"), IF([Description]@row = "112 - Quaking Aspen (5)", [Description]@row = "114 - Ponderosa Pine (10)", "20"), IF([Description]@row = "113 - Western Larch (5)", "12"), IF([Description]@row = "115 - Coffee Burlap bags (1)", "2"), IF([Description]@row = "116 - Tree tubes (1)", "1.75")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!