Indirect Match Formula

  • Hello,

    Im having trouble with this formula

    =INDIRECT("'"&B5&"'!C"&MATCH("Total Actual Retail/Revenue.",'2221866'!B:B,0)&"")-D5

    I just want the '2221866' To be referenced to Cell B5 (like at the start), but I cant seem to get the right notation. Can someone urgently help me?

  • Sorry ignore, the answer is

    =INDIRECT("'"&B5&"'!C"&MATCH("Total Actual Retail/Revenue.",INDIRECT("'"&B5&"'!B:B"),0)&"")-D5

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!