Use Vlookup on 2 Columns?

[gjjh25]

I am trying to use Vlookup to select a cell when two criteria are correct, but I think it maybe the wrong thing to use.

If anyone can help please.

On the enclosed sheet on Gully tab I am trying to get column N to lookup columns A & C and then check on the drun tab for the rows that equal columns A & C and return the value in column H on the Drun tab. So on the highlighted cell it would look for S5 in column A and S6 in column C, going to the drun sheet this would then return the value of 375.

Is this possible to do?

[Pete_UK]

You can use this formula in N11:

=SUMIFS(DRuns!$H$12:$H$55,DRuns!$A$12:$A$55,A11,DRuns!$C$12:$C$55,C11)

then copy down.

Hope this helps.

Pete

[Glenn Kennedy]

Try this:

=IFERROR(1/(1/INDEX(DRuns!$H$12:$H$55,MATCH(1,INDEX((DRuns!A$12:A$55=Gully!A11)*(DRuns!$C$12:$C$55=Gully!C11),0),0))),"")

I put it in Q as you have some data validation in n that needs to be removed.

[gjjh25]

Thank you both for your help, they both worked perfectly

[Pete_UK]

Glad to help - thanks for feeding back.

Pete