SumProduct Formula

[rizmomin]

Hello:

Please refer to attached sheet.

I have data in Range A36:AH67.
Name of Employee is in Row 36
Date Range is in Cell A37:A67

I want a formula to transpose the data in Cell F2:AJ29 for employees listed in Column B

Please let me know if any questions.

Thanks

Riz

[TMS]

F2: =INDEX($F$37:$AH$67,MATCH(F$1,$A$37:$A$67),MATCH($B2,$F$36:$AH$36,0))


Copy down and across.


Regards, TMS

[rizmomin]

Hi TMShucks:

Thank you so much for your great help.

Riz

[TMS]

You're welcome.