To explain the concept, let's pretend I wanted to make lists of cocktails and ingredients.

First off, we have a list of ingredients (gin, rum, campari etc.) and columns of relevant information (cost, ABV, sugar content etc.). I also have a list of recipies. This list has a lookup column, where it looks up the ingredients, and presents the information I have about them in the list. This gives me a list that tells me "recipe A uses ingredients 1, 2, 3; recipe B uses ingredients 2, 4, 5"

But what do I do if I also want a list of what recipies the different ingredients are used in? As in, "ingredient 2 is used in recipes A, B, X, Y"? can I put a lookup column in the ingredient list that looks up what the lookup column in the recipe list looks up? If not, is there some other way to do what I want to do?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.