Suggestion for returning data based on selected criteria

@SPark
@SPark ✭✭✭
edited 01/03/20 in Formulas and Functions

I'm looking for some guidance. I would like a cell to return text (category) based on selected criteria (sub category) -- screen shots below.

Example: If I select 'Wine' from the drop down, I would like the Category cell to return 'Food & Bev'.

I could do an IF statement, however, there are several subcategories in the drop down as well as several categories so I was hoping I was overlooking some kind of VLookup or something easier that could search a range for the categories to return a category. Hopefully that makes sense, any thoughts would be appreciated!!

Category.png Sub Category.png




Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!