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!