C
ChristopherG
I am trying to use the INDEX function, within the INDIRECT function. Even
with a simple reference within the same workbook, I get the #REF! Error.
Examples:
=INDEX(JH!$A:$B,3,2) yields the contents of the cell in the range of the JH
worksheet, row 2, column 2.
If I imbed the above inside the INDIRECT function (needed so that the
reference to the JH worksheet may be a parameter, selected by the user from a
list) it get an error. In final production, the JH! would be replaced by a
text string "&$E$2&"! to allow for the selection in cell E2. I removed the
text string, and substituted a fixed cell reference to troubleshoot the error.
In cell E9 I have: ="INDEX(JH!$A:$B,3,2)"
In cell A9 I have: =INDIRECT(E9,1)
The result is: #REF!
I have been using both the INDEX and INDIRECT functions for a while, but not
with the INDEX imbedded inside the INDIRECT.
Thanks for any help or suggestions.
with a simple reference within the same workbook, I get the #REF! Error.
Examples:
=INDEX(JH!$A:$B,3,2) yields the contents of the cell in the range of the JH
worksheet, row 2, column 2.
If I imbed the above inside the INDIRECT function (needed so that the
reference to the JH worksheet may be a parameter, selected by the user from a
list) it get an error. In final production, the JH! would be replaced by a
text string "&$E$2&"! to allow for the selection in cell E2. I removed the
text string, and substituted a fixed cell reference to troubleshoot the error.
In cell E9 I have: ="INDEX(JH!$A:$B,3,2)"
In cell A9 I have: =INDIRECT(E9,1)
The result is: #REF!
I have been using both the INDEX and INDIRECT functions for a while, but not
with the INDEX imbedded inside the INDIRECT.
Thanks for any help or suggestions.