Doing lookup with Multiple Criteria

[DaKen]

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

 

[Juan Pablo González]

Anything more specific ?

 

[DaKen]

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]

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.