Microsoft Office Forums Match two sets of data and display specific data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2012, 07:13 AM
lolly150 lolly150 is offline Match two sets of data and display specific data Windows 7 32bit Match two sets of data and display specific data Office 2003
Novice
Match two sets of data and display specific data
 
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
  #2  
Old 05-14-2012, 10:33 PM
macropod's Avatar
macropod macropod is offline Match two sets of data and display specific data Windows 7 64bit Match two sets of data and display specific data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Match two sets of data and display specific data Data Set Display Size - PP 2007 TonyMan PowerPoint 1 04-14-2010 05:45 AM
Match two sets of data and display specific data 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
Match two sets of data and display specific data One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM


All times are GMT -7. The time now is 03:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft