Thread: VLOOKUP over multiple columns

A standard VLOOKUP would not suffice I'm afraid given multi conditional test.

You could concatenate A:C on Sheet2 in a new column, say E:

Sheet2!E1: 
=A1&"@"&B1&"@"&C1
copied down for all rows

Then

Sheet1!D1:
=INDEX(Sheet2!$D:$D,MATCH(A1&"@"&B1&"@"&C1,Sheet2!$E:$E,0))

If you opt against the concatenation you'd be looking at a less efficient approach, eg:

=INDEX(Sheet2!$D$1:$D$100,MATCH(TRUE,INDEX(Sheet2!$A$1:$A$100&"@"&Sheet2!$B$1:$B$100&"@"&Sheet2!$C$1:$C$100=$A1&"@"&B1&"@"&C1,0),0))

Note for the 2nd approach we restrict the ranges as much as possible given the inefficient nature of the calculation.