+ Reply to Thread
Results 1 to 4 of 4

Index & Match formula assistance to get Revenue, Space & GM data from different sheets

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    Anaheim, CA
    MS-Off Ver
    Excel 2010
    Posts
    52

    Index & Match formula assistance to get Revenue, Space & GM data from different sheets

    Hello,

    Hopefully someone can help me.

    If you open up the attachment you will find 3 highlighted tabs in yellow.

    I am needing help in doing a formula that probably involves index and match or even an offset formula.

    Would like to know what formula to enter in K443, L443 & M443 (cells highlighted in Yellow)

    The customer Goop, LT are the first two tabs after Secaucus.
    Its vertical on this tab but on the individual tabs it is horizontal

    Budget Revenue can be found on the LT Tab in cell R8
    Budget Space (Square Footage) can be found in cell R9
    Budget GM% can be found in cell R181


    Thanks!

    David Mejia
    Attached Files Attached Files

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,705

    Re: Index & Match formula assistance to get Revenue, Space & GM data from different sheets

    Please try at

    K440
    =INDIRECT("'"&$H440&"'!R9C"&17+F440,)


    L440
    =INDIRECT("'"&$H440&"'!R8C"&17+F440,)

    H440
    =INDIRECT("'"&$H440&"'!R181C"&17+F440,)

  3. #3
    Registered User
    Join Date
    07-20-2013
    Location
    Anaheim, CA
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: Index & Match formula assistance to get Revenue, Space & GM data from different sheets

    Hello quick question if the Column where the revenue is at changes - as lets say its in column S.

    Do i just simply change the formula to show S?

    Or is there something different to do? and what does the c & 17 mean for this formula?

  4. #4
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,705

    Re: Index & Match formula assistance to get Revenue, Space & GM data from different sheets

    This is Formula in RC style R for Row C1 is column A ="C" & 17+F440 ="C" & 17+1 = C18 = Column R

    Drag formula down ="C" &17+F441 ="C" & 17+2 =C19 =Column S
    Attached Files Attached Files
    Last edited by Bo_Ry; 11-11-2019 at 05:03 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1