Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Indirect formula

  1. #1
    Board Regular
    Join Date
    Jun 2015
    Location
    Somerset, UK
    Posts
    434
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Indirect formula

    Hi all,

    I am currently using the formula =INDIRECT($C$2&"!A1") which works fine.

    what I now need is for the box below to be =INDIRECT($C$2&"!A2") and so on, down until A330

    is this possible without manually changing the A1 to A2, A3, A4 and so on?

    Thanks

    Rick

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    5,673
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Indirect formual help

    Hi, in which cell are placing the first formula?
    [code]your code[/code]

  3. #3
    Board Regular
    Join Date
    Jun 2015
    Location
    Somerset, UK
    Posts
    434
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Indirect formual help

    solved using helper column and formula is now INDIRECT($C$2&"!A"&N6)

  4. #4
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    5,673
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Indirect formual help

    Quote Originally Posted by 123rickfear View Post
    solved using helper column
    Hi, you don't specifically need a helper column, you can increment the row counter like this:

    =INDIRECT($C$2&"!A"&ROWS(A$1:A1))

    But for robustness it would be wise to make the A$1:A1 references match the cell where you first enter the formula.
    [code]your code[/code]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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