+ Reply to Thread
Results 1 to 22 of 22

indirect function to reference cell on different sheet

  1. #1
    Registered User
    Join Date
    08-10-2005
    Posts
    18

    indirect function to reference cell on different sheet

    ok, I have a situation where I have 2 cells on sheet2 that define the starting and stopping points of a range that I need to reference. I need to reference them from another sheet (sheet1). I cannot however get it to work.

    for example,
    on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a cell on Sheet2, but I need to get the cell in sheet2 that is referenced by cell a1 in sheet2 back into sheet1

    it doesn't like the first 'Sheet2'!, it keeps giving me an error. I can take it off so that I am left with =indirect('Sheet2'!a1) but then it will be referencing a cell on sheet1. I am just not sure what the correct syntax is.


    Actually this is just part of a much larger equation...but this is the part I can't seem to get to work.

    thanks in advance for any help

  2. #2
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  3. #3
    Registered User
    Join Date
    08-10-2005
    Posts
    18
    yep that was it...thank you very much...I knew it was going to be something simple....I just couldn't get it.

  4. #4
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  5. #5
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  6. #6
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  7. #7
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  8. #8
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  9. #9
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  10. #10
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  11. #11
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  12. #12
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  13. #13
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  14. #14
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  15. #15
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  16. #16
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  17. #17
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  18. #18
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  19. #19
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  20. #20
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  21. #21
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


  22. #22
    Duke Carey
    Guest

    RE: indirect function to reference cell on different sheet

    Are you saying that A1 on Sheet2 contains a reference such as "C3" ?
    And you want to reference the value in C3 on Sheet2?

    =indirect("'Sheet2'!"&'Sheet2'!a1)


    "Dolemite" wrote:

    >
    > ok, I have a situation where I have 2 cells on sheet2 that define the
    > starting and stopping points of a range that I need to reference. I
    > need to reference them from another sheet (sheet1). I cannot however
    > get it to work.
    >
    > for example,
    > on sheet1 -----> ='Sheet2'!indirect('Sheet2'!a1)
    > cell a1 on sheet2 contains a cell reference (a2, g3, or whatever) for a
    > cell on Sheet2, but I need to get the cell in sheet2 that is referenced
    > by cell a1 in sheet2 back into sheet1
    >
    > it doesn't like the first 'Sheet2'!, it keeps giving me an error. I
    > can take it off so that I am left with =indirect('Sheet2'!a1) but then
    > it will be referencing a cell on sheet1. I am just not sure what the
    > correct syntax is.
    >
    >
    > Actually this is just part of a much larger equation...but this is the
    > part I can't seem to get to work.
    >
    > thanks in advance for any help
    >
    >
    > --
    > Dolemite
    > ------------------------------------------------------------------------
    > Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
    > View this thread: http://www.excelforum.com/showthread...hreadid=397194
    >
    >


+ 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