cell referancing
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: cell referancing

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Want to create a cell referance like this,
    A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.

    thanks for the help
    happy easter

  2. #2

    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-29 05:35, drag-driver wrote:
    Want to create a cell referance like this,
    A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.

    thanks for the help
    happy easter

    =INDIRECT("A" & B3)

    "whats the story with for loops can they run in excel" ......Yes.


  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,869
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    Want to create a cell referance like this,
    A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.


    =INDIRECT("A" & B3)


    And:

    =OFFSET(A1,B3-1,0)

User Tag List

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
  •  

 

 
DMCA.com