Excel: Linked Lists and Value LookupLocked
Hello! This is my first post, but I have been actively searching this forums for sometime. Thank you everyone for such great help – now I ask for some. I am going to attempt to explain this as best I can.
I have 4 lists of data and they are not all equal. Column A comtains all my juice flavours (blueberry, grape, apple). Column B contains a choice between values in Column A with sugar and without sugar. (So if from the drop down I select Apple and the next is populated with Sugar and Non-Sugar – but not all the flavours have this option, some are fixed with Sugar). Column C contains the names of the beverage in question which is dependant on the flavour and sugar option.
I have a linked list between the flavour and sugar, such that when I choose the flavour it will populate the next drop down with the sugar/non-sugar option. The problem is that since there are many names of beverage the I run into issues. If I continue using the linked list it will populate ‘blanks’ in my sugar/non-sugar list and or the beverage list.
Is there another way (I am assume using VLOOKUP) to match flavour with sugar/non-sugar option and display those beverage names?? I can not use VBA (need to have the code in the cells for security – no macros).
Thank you very much! If you need the code thus far I can post, but just something generic which I can change will work. Thank you again.