Transpose Data

[rizmomin]

Sheet1 has monthly data for each client.
Depending on the month I enter in cell c2 of Sheet2, I need the formula to copy the data from sheet1 into sheet2,column C as currently shown in Sheet2.

Please help....

Thank you,

Riz

[Trebor76]

Hi Riz,

I may have a solution but you'll need to change your thread title (perhaps to "Link Data Based On Cell Reference") for me to suggest it for as it currently stands it's not descriptive of your problem i.e. you don't need to transpose data at all.

Regards,

Robert

[rizmomin]

I would be ok with that if it works.
i was thinking SUMPRODUCT or LOOKUP function would work but i am not sure how to create the formula...

Please reply..

Thank you,

Riz

[Trebor76]

I was able to create a combined formula using four different functions without transposing any data.

[rizmomin]

Can you please the formula...

Thank you,

Riz

[Trebor76]

Hi Riz,

Let me know if putting the following formula in cell C3 of Sheet2 (and copied down as required) solves the problem:

Please Login or Register  to view this content.

HTH

Robert