#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
hi lolly150,
If you attach some sample workbooks, you may make more progress. To attach files, use the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |