Create drop down menus linking from other sheets

Hello.

I am trying to create a diet sheet.

Basically the first sheet will have a list of meals 1-5.
Each meal should have dropdown menu's underneath so I can select foods that I will enter in the second sheet.

When I select the food, I want it to copy the whole row (Food name | calories | protein | carbs | fat ) into the first sheet under the meals.

How hard is this?

I have no idea where to start, I tried looking at a few tutorials but they were for different things.

Hi there,

Here is what I just done.

Sheet2: \1

I created this and selected cells A2>E6 (Everything but the headers).
I then clicked on Forumla/Name Manager/ and named it "Foods"

I then went to sheet1 and created this: \1

I highlighted those cells, and clicked on: Data / Data Validation / Allow: List / Source=Foods

It then says: The list source must be a delimited list, or a reference to a single row or column.


If I highlight only a certain row or column in sheet 2 and create a name, and use it as a source in sheet 2 it will work.
But I want to create dropdown "rows", so when I select a food from the downdown list, it will paste over the whole row (the calorie information, protein, carbs etc.

Anyone at all know?

Thanks for that.

I still have no idea how that works but its what I am trying to do.

do you have any good tutorials I can read on vlookup?

Thanks sorted it out, many thanks for the attachment 00able.