Excel 2007 : how to get a drop down menu choice to change adjacent cells

[bstinson]

I am creating a price list that contains multiple items in different combinations, for example I have multiple parts that can be sold separately or in a system.

I would like to have a section in the price list that combines a number of parts to create a complete system and get the final price. I have been able to create lists using data validation and name Manager but after that I get lost.

Example:
A26 contains a list of 4 options which are located in A6:A9. A6 is the product name, b6 is the product code, c6 is the MSRP etc... all the way to H6. What I would like is that when A6 is selected from this drop down menu in A26 I would like the adjacent cells to the right of A26 to automatically be filled in with the contents from A6 through H6 so that when I am making a customized system I can chose the products I need and have the prices imputed automatically instead of adding them all up separately.

I have attached a sample price list with what I am trying to accomplish. My understanding of excel formulas is pretty basic so please don't take anything for granted when explaining.

Help is very much appreciated and look forward to hearing some suggestions.

Thank you very much.

[NBVC]

In B25 enter:

=IF($A25="","",INDEX(B$1:B$22,MATCH($A25,$A$1:$A$22,0)))

copied down to B27 and across the columns

[bstinson]

It worked like a charm and I have been able to adjust it slightly to work in other pages. Thank you very much for your precise and speedy response. I will look up on my own what all the symbols mean to try and reverse engineer that formula so I understand where it came from. Thanks again.