Hi

Have a look at Data/Filter/Autofilter.


--
Andy.


"armindo" wrote in message
...
Hi

I have an excell sheet with columns city and comercename i would like to
make a dinamic cell that searches for city=Lisbon & comercename=cars and
it
would search the entire database and crate an output with all entries
witch
respected city=lisbon and comercename=cars. How to?