Thread: Match two sets of data and display specific data
View Single Post
 
Old 05-13-2012, 07:13 AM
lolly150 lolly150 is offline Windows 7 32bit Office 2003
Novice
  
Join Date: May 2012
Posts: 1
lolly150 is on a distinguished road
Default Match two sets of data and display specific data
I have two separate worksheets: referral and contact

I'm trying to find a formula that looks at Column A on both sheets (each client is allocated a unique number) and if they match, enter in column D of the referral sheet the month they were seen but only if it is a 1st contact (appt type on column D of contact sheet)

Referral

Reply With Quote