Hi there,
I have a spreadsheet that I am trying to get a formula to work for.
Attached is the sheet.
In the plans sheet I want to enter the food into column C6 downwards. In each of the cells there is a dropdown menu that links to items on the foods sheet.
What I would like to do is when one of the dropdown's is slected in the plans sheet the data as listed on the foods sheet related to that appear.
In cell D6 of the plans sheet I already have some formula that I have used on a previous sheet but some reason this doesn't want to work here.
Any clever person out there able to explain to me why?
Thanks in advance for your help!
Bookmarks