# How to make a dropdown list pull data from another sheet and autofill underneath the list.

1. ## How to make a dropdown list pull data from another sheet and autofill underneath the list.

I have a dropdown list for days of the week, for example Monday, Tuesday,...Sunday Etc. I want to be able to select a value from my list and it fills the 10 cells below it with data from sheet 2.
I want to have different data that is filled based upon the value selected, for instance if I select monday I want the 10 cells below it to say Hot Dog, Hamburger, or Pizza. If I select Tuesday I want it to say Brocolli, Squash, or salad. I would place those values on sheet two, but what is the command to accomplish this function?

2. ## Re: How to make a dropdown list pull data from another sheet and autofill underneath the l

If I understand you correctly, you'll want to do this:

1. In sheet2, you'll have two columns (A and B). In column A you'll list Monday1 Monday2 Monday3 all the way to Monday10, Tuesday1 Tuesday2 Tuesday3 all the way to Tuesday10, etc. In column B you'll put the 10 foods for each day. So B1 would be the food for Monday1.
2. In sheet1 put your dropdown list in B1. In A2 through A11 you'll have the numbers 1 through 10. In B2 through B11 you'll have a formaula that looks up the data (the foods) in sheet2 column B.
3. Using a VLOOKUP, your formula would be something like this: =VLOOKUP(\$B\$1&\$A2,sheet2!\$A\$1:\$B\$70,2,FALSE)

Hopefully that's what you meant.

3. ## Re: How to make a dropdown list pull data from another sheet and autofill underneath the l

I tried to get it to work, but instead I made a copy of my current sheet, and I want to see if you can help me out by possibly fixing up my formulas Example.xlsx

4. ## Re: How to make a dropdown list pull data from another sheet and autofill underneath the l

Example_2.xlsxAttached.

Fixed your named range CLASSES, made two new columns (highlighted in yellow), and put formulas in the cells beneath the drop down.

5. ## Re: How to make a dropdown list pull data from another sheet and autofill underneath the l

You have helped me out tremendously. Thank you so much!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1