Vlookup if formula needed

[drettmannc]

Hi I am looking for a formula that can vlookup based on multiple criteria. I need a formula for F4 (on spreadsheet 1) that will look up the value of column F (on spreadsheet 2) if column E (on spreadsheet 2) equals "Claro" and Column A equals the site number in A4 (on spreadsheet 1) and column D is equal to .25km.

Tall order hope you guys can assist!

Spreadsheet 1:

Spreadsheet 2:

 

[DanteAmor]

Change "Sheet2" to the name of your sheet. Change "10" to the last row with data from sheet2

=INDEX(Sheet2!F1:F10,SUMPRODUCT((Sheet2!A1:A10=A2)*(Sheet2!D1:D10="0.25km")*(Sheet2!E1:E10="Claro")*(ROW(Sheet2!F1:F10)))) <tbody> </tbody>

<tbody>
</tbody>