Hi sheva

See <Arbitrary Lookups
http://www.cpearson.com/excel/lookups.htm#DoubleLookup

But maybe you can use DataAutoFilter ?



--
Regards Ron de Bruin
http://www.rondebruin.nl


"sheva" wrote in message ...
Hi, everyone!

I use Vlookup for searching a cell value, but the function always shows only
the first result, that found. I would need the other values too, that matches
my criteria. How can i see all the results, not only the first?