Auto Fill Columns Based on List Selection

**Pera** · 10-08-2009, 11:09 AM

Hello all,

What I would like to accomplish is simply this;

I have 3 columns, A, B, and C

I have user select a value from a list of possible 40 values in Column A. Based on their selection, I would like to have column B, and C auto filled in. For example if I have this

Apple Red 5
Banana Yellow 3
etc.

So if the user select Apple from the drop down in column A, I want Excel to auto populate column B with Red, and C with 5. I appreciate any help with this.

Thanks!

**Leith Ross** · 10-08-2009, 11:14 AM

Hello Pera,

Where do the values for columns "B" and "C" come from?

**Pera** · 10-08-2009, 11:25 AM

Originally Posted by Leith Ross

Hello Pera,

Where do the values for columns "B" and "C" come from?

They are in a seperate tab within the same worksheet. Like in tab2 in column A I have al the List values for the column A in tab1. Same for the column B, and C.