Take a look at Data Filter AutoFilter......

Vaya con Dios,
Chuck, CABGx3


"LuckyStar" wrote
in message ...

I have a problem that I'm not able to solve:
Check this table:

DATE CUSTOMER RIVISTA
02/01/1997 BIANCHI Automobili
02/01/1997 BIANCHI Barche
05/01/1997 ROSSI Foto
05/01/1997 ROSSI Video
07/01/1997 VERDI Spettacolo
08/01/1997 NERI Modellismo
10/01/1997 VERDI Moda
12/01/1997 VERDI Viaggi

I would like to search by DATE and CUSTOMER column and get RIVISTA
fileds as result !
I.E: find by "05/01/1997" and "ROSSI" and get as result a string with
"Foto and Video". Maybe it could be fine also an array instead of a
string...but then I don't know how I can get values from array.

Any suggestions will be very appreisiated!!!!!
Thanks.


--
LuckyStar
------------------------------------------------------------------------
LuckyStar's Profile:
http://www.excelforum.com/member.php...o&userid=33074
View this thread: http://www.excelforum.com/showthread...hreadid=528860