Excel 2007 : [SOLVED]Auto Fill Columns Based on List Selection

[Pera]

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!

[JBeaucaire]

I use a simple INDEX/MATCH for this function, but you can also use VLOOKUP() or LOOKUP() depending on some other restrictions. Here's a sample sheet showing exactly how it's done.

http://www.excelforum.com/excel-gene...ame-row.html#3
http://www.excelforum.com/attachment...tch-sample.xls

[Pera]

I use a simple INDEX/MATCH for this function, but you can also use VLOOKUP() or LOOKUP() depending on some other restrictions. Here's a sample sheet showing exactly how it's done.

http://www.excelforum.com/excel-gene...ame-row.html#3
http://www.excelforum.com/attachment...tch-sample.xls

This did the trick. Thanks a ton!!