KapardhiSarma
New member
- Joined
- Dec 6, 2012
- Messages
- 5
- Reaction score
- 0
- Points
- 0
I am looking for a formula which helps me with retrieving data comparing the row header and column header.
Attached the file for reference. My answer should be as follows.
I have pivots in "Team Performance - Pivots" tab, and in "Summary" tab, i have different resources in columns and week no.s in rows.
I need a formula in "Summary" Tab which picks up data corresponding to Week No.s available as row headers in both the tabs comparing comparing resource names in columns of both the tabs.
Please let me know if you have any questions.
Thanks,
Kapil
Attached the file for reference. My answer should be as follows.
I have pivots in "Team Performance - Pivots" tab, and in "Summary" tab, i have different resources in columns and week no.s in rows.
I need a formula in "Summary" Tab which picks up data corresponding to Week No.s available as row headers in both the tabs comparing comparing resource names in columns of both the tabs.
Please let me know if you have any questions.
Thanks,
Kapil