Can Excel help with this?

[azkookie18]

Hello, I'm looking for a tool (preferably out of Microsoft Office) to help me with the following:
I'm trying to develop a selection tool for a manufacturer based on the criteria I load.

For example, if I were looking to buy a car. I want to develop a tool in which I can load specifications available by different manufacturers and have this tool let me know which manufacturer(s) can manufacturer that type of vehicle.
For example, I would select the type of engine, number of doors, and color option and would want the tool to output who can make that.
Does anyone have any ideas of how, if at all, Excel can help with this?

Your reply is appreciated

 

[rs2k]

If you load all the data from the manufacturers into a spreadsheet, then AutoFilter will do this,

example: filter on 'engine' and it will give all options, just choose which one you want, say 2.0 litre and it will show results for all manufacturers that produce 2.0 litre engines, then move onto the next criteria and so... and so,

HTH
Colin

 

[Joe4]

If you are going to cross-post on this Board, we request that you provide links to your other post:
http://www.mrexcel.com/forum/showthread.php?t=448897