How can match or lookup values from two separate tables?

klawk26 · #1 07-29-2012, 11:01 AM

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.

macropod · #2 07-31-2012, 09:04 PM

Try the following as an array formula (which you input with Ctrl-Shift-Enter):

Code:

=INDEX('Report 2'!C:C,(MATCH('Report 1'!A2&'Report 1'!F2,'Report 2'!A:A&'Report 2'!D:D,0)))

Note: I haven't tried to suppress the errors that occur when no match occurs. Doing so is quite simple.

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