OK guys...
I have a table that has a list of herbs and spices, and the foods that they are commonly used to season. This is the master table that I values into.
Here's an example
Herb/Spice Complements Oregano Chicken, Potatoes Curry Chicken, Rice Onion Beef, Pork, Chicken, Potatoes Garlic Chicken, Potatoes, Tomatoes Pepper Beef, Potatoes
This isn't the whole table, just an sample.
What I want to do, is on a separate sheet have a table that shows the reverse:
Food Suggested Seasoning Chicken Oregano, Curry, Onion, Garlic Beef Onion, Pepper Pork Onion Potatoes Onion, Pepper Rice Curry Tomatoes Garlic
I want this table to pull from the first one so that I only have to update the primary table.
I figure this will involve un-concatenating the lists from the first table (which I can do, I can also re-concatenate them into the second column list on the secondary table)
I just started getting an enormously complex formula, so I figured I would ask if there was an easier way.
Thanks, everybody!
Bookmarks