Hi All,

Firstly, let me explain I'm new to using Excel at a more than beginners level.

I've searched the web and forums, but the problem is I don't know the lingo... It's hard to search for things when you don't know what you're searching for!

So here's what I need to do:

- I have a table of ~800 cars with various columns explaining engine size, colour used etc.

- I need to figure out how to show which cars are available if my user has said he wants so-and-so engine size and wants a certain colour.

I have figured out how to select these various factors within the table, but I need to create a formula where I can say, I want this engine size, this colour etc and then excel gives me a list of cars available.

Any help would be GREATLY received!

Best,
Scott