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.