Auto Fill a cell based on drop down selection in a another cell

**Doc True** · 02-25-2009, 10:43 AM

Can you please help a Newbie?

I have a document that has a dropdown list of names. The cell next to it needs a doller amount that corrosponds to the individual names. Can this second cell be filled automatically? It would look something like this:

Joe 150.23
Bob 75.89

I'm sure this is unbelievably simple, and I appologize if it has been answered before. This is my first post here so if I have not provided enough information please let me know.

**NBVC** · 02-25-2009, 10:48 AM

I assume you have a list of names and corresponding $ amounts somewhere in the sheet....if not, create one or tell us how you get the values.

If so, then use Vlookup()

e.g.

=Vlookup(A1,$X$1:$Y$100,2,False)

where A1 contains your drop down list and X1:Y100 contains the lookup table.

**Doc True** · 02-25-2009, 03:43 PM

This is outstanding! I have it working except for one thing I neglected to mention. The data are arranged in colomns. Names in one, $ in the the other. The second column sums at the bottom, and there will be several cells along the column that will be blank. As is, when the cells are blank, they're returning a #N/A error and preventing the sum. Is there a way to prevent this?

**NBVC** · 02-25-2009, 03:48 PM

Try replacing formula with this one

Please Login or Register  to view this content.

adjusting ranges/references to suit.

**KWayland** · 03-07-2013, 06:23 AM

Hello,

I have a similar problem but the final code doesn't seem to solve.

I have a drop down list (list of flyers: i.e. A4 handout) B3 and I want this to populate cell C3 with the number of stock (i.e 100). I've created a table of data to read from and your initial method worked but I had the same "#N/A" problem. I too want empty cells to remain blank or have 0.

I've tried copying in the above formula and Excel says it's wrong.

Please help as this has been the most helpful post so far.

**arlu1201** · 03-07-2013, 07:29 AM

KWayland,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.