Auto fill line when item is chosen from drop down list.

You usually make use of the VLOOKUP function to pull data into other cells on the same row as your drop-down.

Post an example workbook so we can quote a formula which will suit your data layout.

Hope this helps.

Pete

Okay, here is what I have so far. I used the information at the top of the page to create the drop down list for the name and size. What I would like it to do is when I choose a name of the item, for it to auto fill in the type, criteria and manufacturer. I entered a formula in the type cell that someone had given me before, but it does not seem to work the way I would like it to.

Not sure why you have merged cells, but put this formula in H37/I37:

=VLOOKUP(G1,$G$1:$J$34,2,0)

Remove the data validation from J37, and put this formula in there:

=VLOOKUP(G1,$G$1:$J$34,3,0)

Finally, remove the data validation from K37/L37, and put this formula in K37:

=VLOOKUP(G1,$G$1:$J$34,4,0)

Hope this helps.

Pete

Hi Pete,

That works for getting the information for the first item on the drop down menu. But how would I get it to work for any item that is chosen? This way if they were to choose HRC 555 for example, then it would auto fill forged head type and the rest of the corisponding information to the right.

I'm sorry - I started from your original formula, which was wrong. Instead of the first G1 in those 3 formulae, you should change it to G37. That way, if you go to G37 and select another item from the list - the following three items of data will change according to the selection. If you want to be able to make multiple selections, then just copy those formulae down.

Hope this helps.

Pete

That works perfect! Thank you so much for all of your help Pete! You are amazing with Excel and a big help.