I have the following scenario.
--

Client Worksheet
MAILED COMPANY TITLE FIRST LAST
Xxxxxxxx Acton Flooring Inc. Ms. Marsha Acton
Xxxxxxxx AcuTech Ms. Linda Dendy
Xxxxxxxx Adams and Reese Mr. David Hunt
Xxxxxxxx Adams and Reese Ms. Deborah Hunt


Misc Worksheet
COMPANY DATE1 DATE2 TITLE FIRST LAST
Acton Flooring Inc. 12/01/05 N Ms. Marsha Acton
AcuTech 12/01/05 N Ms. Linda Dendy
Adams and Reese N N Mr. David Hunt
Adams and Reese 12/01/05 N Ms. Debora Hunt


I use the following formula to retrieve my date:
=INDEX(Misc!$A:$C,MATCH(C2,Misc!$A:$A,0),2)

The problem with this is it will retrieve the €œN€� for the first occurrence
of Adams and Reese. If I mailed a letter to Ms. Debora Hunt, I want the
12/01/05 date to populate the MAILED column.

hgopp99