Try

=INDEX(Sheet2!C2:C20,MATCH(A4&B4,Sheet2!A2:A20&She et2!B2:B20,0))

entered with ctrl + shift & enter

where you would return values from C2:C20 where A4&B4 match in A2:B20


Regards,

Peo Sjoblom

"o1darcie1o" wrote:

I have 5 columns on two worksheets, same book, idential columns. I want
columns c, d, and e to populate from the 2nd sheet if columns a & b are the
same on both. I need the combination of column a to column b to match (items
are doubled in column a; last three columns are determined then by b).
I tried VLOOKUP (using A2:B2 as the lookup) but that didn't work. I've
tried different IF and AND formulas, and just can't seem to get it right.
Can someone help please?!?!