|
|
#1
05-13-2012, 07:13 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
 Data Set Display Size - PP 2007
|
TonyMan | PowerPoint | 1 | 04-14-2010 05:45 AM |
|
Finding the complements between the two data sets
|
psenku | Excel | 2 | 08-17-2009 11:15 PM |
| How can I use a colom of data if a specific value is found. | Grapejuice | Excel | 1 | 08-11-2006 11:44 PM |
|
One bar chart for 3 sets of data
|
rclloyd | Excel | 1 | 02-03-2006 09:51 AM |
Windows 7 32bit 
Office 2003
Threaded Mode