I have spread sheet - with this type of data below

[]Date [] Ticket []Caller []Email[]Caller Organization[]Open Group[]

EX.

[]3/13/2006 [] 1316298[] Jones,David [] []NTK
[]Home
[]3/14/2006 [] 1316498[] Blue,Matt[] []TEAM []Home
[]3/14/2006 [] 1317798[] Nap,John[] []OUT[]Home

i have another spread sheet that has a list of people.
EX.





I want to use my email list to search my first spread sheet.

so if I ran this - based on the data i have above
[]3/14/2006 [] 1316498[] Blue,Matt[] []TEAM []Home

Matt blue ticket would out put since his email was in the seach list.

any help would be great.. I hope you painted the picture


--
appz
------------------------------------------------------------------------
appz's Profile: http://www.excelforum.com/member.php...o&userid=32461
View this thread: http://www.excelforum.com/showthread...hreadid=522407