Results 1 to 1 of 1

Thread: Get data comparing Row Header and Column Header in a new sheet

  1. #1

    Get data comparing Row Header and Column Header in a new sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •