Looking up values based on columns

[testarossa93]

Hi excel forum,

Please see the attached file.

I am trying to lookup values into cells D10:D13 and E13 based on the date from A10:A13. The dates in A10:A13 are coming from a different sheet, but the issue I'm having is looking up the values from A10:A13 against D1:O1 and then return the values from that column.

How can I proceed with this?

[Pete_UK]

You can put this formula in D10:

=VLOOKUP($B10,$A$3:$O$6,MATCH($A10,$A$1:$O$1,0),0)

and copy it down into D11:D12.

You can also copy it into E13, but then you would need to change it to this:

=VLOOKUP("Grand Total",$A$3:$O$6,MATCH($A13,$A$1:$O$1,0),0)

Hope this helps.

Pete

[CARACALLA]

D10=ABS(SUMPRODUCT(($A$3:$A$5=$B10)*($D$1:$O$1=$A10)*($D$3:$O$5))) copy down

E13=SUM(D10:D12)

[testarossa93]

D10=ABS(SUMPRODUCT(($A$3:$A$5=$B10)*($D$1:$O$1=$A10)*($D$3:$O$5))) copy down

E13=SUM(D10:D12)

You can put this formula in D10:

=VLOOKUP($B10,$A$3:$O$6,MATCH($A10,$A$1:$O$1,0),0)

and copy it down into D11:D12.

You can also copy it into E13, but then you would need to change it to this:

=VLOOKUP("Grand Total",$A$3:$O$6,MATCH($A13,$A$1:$O$1,0),0)

Hope this helps.

Pete

Thanks!

Both solutions worked, but I'll use VLOOKUP as I'm too inexperienced with the sumproduct function.