I want to create a BESTBUY type comparison in Excel. I want to pick 3 items from a list of 12 items and have them compared side by side. Here are my thoughts:

1. Sheet 1 is main page. Sheets 2-13 contain info on each of the 12 different products. Sheet 2 is Widget1, Sheet 3, is Widget2, etc.
2. Column A would have fields of main sales items, such as: warranty, size, color, etc. This exact column would be one each of the product sheets 2-13.
3. Field B1, C1, & D1 would have drop down menus showing all 12 products. A different choice would be chosen for each of the 3 fields.
4. Once a choice is made in the above listed drop down boxes, the fields would auto populate based on the choice. For example, if B1 showed that Widget1 was selected, then the fields (warranty, size, color, etc) would be filled with info from sheet 2.


My question is how to best auto populate the fields. I suppose that I could nest 12 "if/then" statements inside each other for the fields of B2, B3, B4, etc. Is this the best approach? Any suggestions?