How can match or lookup values from two separate tables?

		Microsoft Office Forums > Microsoft Excel > Excel
How can match or lookup values from two separate tables?

FAQ

Thread Tools

Display Modes

07-29-2012, 11:01 AM

klawk26

Windows XP How can match or lookup values from two separate tables?

Office 2003

Novice

Join Date: Jul 2012

Posts: 1

How can match or lookup values from two separate tables?

On the attached worksheet, what is a good formula for taking the personnel # and Occur Date on tab entitled "Report 1" to match the Disciplin.Event Date On tab entitled "Report 2" and bring back the "disciplinary event" to "report 1" worksheet.

Note that there are 5 lines of information on Report 1 and only 4 lines of info on Report 2. Dates must match.

Attached Files

Attendance Test.xls (13.5 KB, 18 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM
Any easy way to separate a Word document into separate files?	SamHelm	Word	0	08-21-2010 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:30 AM.