Retrieving an Item from a List that Meets Multiple Criteria
 

I would like to get Date1 (and Date2) from Worksheet Misc and place it
in Worksheet Client. I have been using the following function:
=INDEX(Misc!$A:$C,MATCH(C259,Misc!$A:$A,0),2).
This will work when there is one instance of the company or the dates
are the same for multiple instances. It will retrieve the first date
when there is more than one occurrence of a company, but I need each
one, probably matched on company and last/first name

Worksheet: Client
Date1----Date2--- Company------------------Title------First-----Last
Xx/xx/xx- xx/xx/xx-Associated Data
Services---Mr.-------Jerry-----Stofel
Xx/xx/xx- xx/xx/xx-Associated Grocers---------Mr.-------Ron------Burke
Xx/xx/xx- xx/xx/xx-Associated Grocers---------Ms.-------Jackie---Plott

Worksheet: Misc
Date1----Date2--- Company------------------Title------First-----Last
12/01/05--N------Associated Data Services---Mr.-------Jerry-----Stofel
-N--------N------Associated Grocers---------Mr.-------Ron------Burke
01/13/06--N------Associated Grocers---------Ms.-------Jackie---Plott

I have gotten replies about changing the function to an array, but I
have not understood the replies or research on the subject. If someone
could "dummy it down" for me a bit, I would appreciate it.


--
hgopp99
------------------------------------------------------------------------
hgopp99's Profile: http://www.excelforum.com/member.php...o&userid=30699
View this thread: http://www.excelforum.com/showthread...hreadid=503622