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?

07-31-2012, 09:04 PM

macropod

Windows 7 64bit How can match or lookup values from two separate tables?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:54 AM.