Share via

In Excel 2016 for Mac Does INDIRECT() function work?

Anonymous
2018-04-20T03:43:10+00:00

In Excel 2016 for Mac Does INDIRECT() function work?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-20T04:52:44+00:00

    INDIRECT works irrespective of the OS. What is the formula which you are using and what is the error?

    The formula in which I am using INDIRECT is =IF($J$2=INDIRECT(O2&"!D2"),INDIRECT(O2&"!E2"),)

    The cell O2 contains 'Sheet Name'

    The cell D2 contains B12

    The cell E2 contains C12

    I get no error message. The formula above appears in its cell as though it were text; none of the references have been resolved. Thank you for responding to this problem. The text strings in $J$2 and in 'Sheet Name'!B12 match, so I expect to see the contents of 'Sheet Name'!C12 in the cell which contains the formula.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-04-20T04:54:52+00:00

    Make it

    =IF($J$2=INDIRECT(O2&"!"&D2),INDIRECT(O2&"!"&E2))

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-04-20T03:52:45+00:00

    INDIRECT works irrespective of the OS. What is the formula which you are using and what is the error?

    Was this answer helpful?

    0 comments