Hey all, great community.

I have put together a lot of product information for various products, and trying to get my head around how best to setup a comparison sheet.

What i want to be able do is compare using 2 drop down menus for up to 6 products.

First drop down menu would be from Manufacturer column, then that would limit the second drop down box to show only those models associated with that Manufacturer. After selecting both, it would show the Feature data for that particular model.

sample sheet.xlsx

Appreciate any help offered.

Regards
Rob