Match & Sumif Formula

[rizmomin]

Hello:

Please refer to attached file.
I need formula in cell I8 and K8 down to get the value from column Q thru AC.
Column I value will be based on date range shown in cell H3 (dropdown list).
Also need to match catogory shown in cell H8 down with catogory in cell P8 down.

Let me know if you have any questions.
Thanks.

Riz

[PaulM100]

I8: =INDEX($Q$8:$AC$15,MATCH($H8,$P$8:$P$15,0),MATCH($H$3,$Q$4:$AB$4,0))
K8:, You need the vcalues found in column AC or what Sumif?

[63falcondude]

Try these:

I8 =INDEX(Q$8:AB$13,MATCH(H8,P$8:P$13,0),MATCH(H$3,Q$4:AB$4,0))

K8 =INDEX(AC:AC,MATCH(H8,P:P,0))

Edit: Oops, Paul beat me to it.

[Sam Capricci]

I'm not sure why you couldn't use an HLOOKUP for the column I values like this...
=HLOOKUP($H$3,$Q$4:$AB$14,ROW(5:5),FALSE)
dragged down.
also not sure why you can't just point to the overall total with =AC8 dragged down unless the values in cells H8 to H13 and the ones in P8 to P13 will change.

[AlKey]

Try this
Enter in I8

Please Login or Register  to view this content.

Enter in K8

Please Login or Register  to view this content.

[rizmomin]

Hello:

Thanks a lot to all of you.
Riz

[Sam Capricci]

don't know which you used BUT, thank you for the rep!

[63falcondude]

Glad we could help. Thanks for the rep!