what do you want to do with em after they are caught?
You may be wanting to look at countif or sumif functions.

--
Don Guillett
SalesAid Software

"Valley" wrote in message
oups.com...
When lookup_value corresponds several value in table array, it only
catchs the first value/cell with vlookup function, how to catch the
second and more value?