Suggestion for returning data based on selected criteria
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!!
Help Article Resources
Check out the Formula Handbook template!