Doing lookup with Multiple Criteria

DaKen · Mar 28th, 2002, 12:32 PM

I need to pull info from 2 different sheets within a workbook where info in 2 columns match. Any help?

Juan Pablo González · Mar 28th, 2002, 12:43 PM

Anything more specific ?

DaKen · Mar 28th, 2002, 01:12 PM

Sample data:
Sheet 1
Column 1 colmn 2
004 Red
004 Blue
006 Red
004 Green
006 Blue

Sheet 2
Column 1 Coumn 2 Coulmn 3
006 Blue 25
004 Blue 50
004 Red 20
006 Green 10

I want to pull what's on Sheet 2 in column 3 if Sheet 1,Col 1 and 2 match Sheet 2, Col 1 and 2.

Hope this clarifies.

Juan Pablo González · Mar 28th, 2002, 01:19 PM

How about this ?

{=INDEX(Sheet2!C1:C4,MATCH(A1&B1,Sheet2!A1:A4&Sheet2!B1:B4,0))}

This is an array formula, it must be entered with Control Shift Enter, not just Enter for it to work.

Mar 28th, 2002, 12:43 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Anything more specific ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 01:19 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	How about this ? {=INDEX(Sheet2!C1:C4,MATCH(A1&B1,Sheet2!A1:A4&Sheet2!B1:B4,0))} This is an array formula, it must be entered with Control Shift Enter, not just Enter for it to work. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Mar 28th, 2002, 12:32 PM	#1
DaKen New Member Join Date: Feb 2002 Posts: 43	I need to pull info from 2 different sheets within a workbook where info in 2 columns match. Any help?

Mar 28th, 2002, 01:12 PM	#3
DaKen New Member Join Date: Feb 2002 Posts: 43	Sample data: Sheet 1 Column 1 colmn 2 004 Red 004 Blue 006 Red 004 Green 006 Blue Sheet 2 Column 1 Coumn 2 Coulmn 3 006 Blue 25 004 Blue 50 004 Red 20 006 Green 10 I want to pull what's on Sheet 2 in column 3 if Sheet 1,Col 1 and 2 match Sheet 2, Col 1 and 2. Hope this clarifies.