Searching for different items
 

Hi

I'm creating an excel database with 2 tabs - one of which will be a front
page, containing formulas to conduct a search from tab 2 - a data dump page.

I understand how to do VLookups, but i'm looking for a formula which means I
can search for E.g :

Look for Fred, In warrington, with Volvo - is this possible to search for
several items ??

Anything you can help me with will be much appreciated.


RGDS
Ben

Searching for different items
 

=INDEX(E2:E20,MATCH(1,(A2:A20="Fred")*(B2:B20="War rington)*(C2:C20="Volvo"),0))


entered with ctrl + shift & enter



--


Regards,


Peo Sjoblom


"B_cooper123" wrote in message
...
Hi

I'm creating an excel database with 2 tabs - one of which will be a front
page, containing formulas to conduct a search from tab 2 - a data dump
page.

I understand how to do VLookups, but i'm looking for a formula which means
I
can search for E.g :

Look for Fred, In warrington, with Volvo - is this possible to search for
several items ??

Anything you can help me with will be much appreciated.


RGDS
Ben