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

Thread: =indirect Function

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have used the =indirect function which allows me to insert a filename and get the contents of a cell, therefrom. But it is not relational, if I copy this function to another cell it does not change the target cell.

    Any ideas on how to make it relational?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try referencing the cell from another cell.

    for example =indirect("'[eg formulas.xls]Time and Date Formulas'!"&a1)

    where A1 contains the cell reference.

    If your doing the above for a whole table I alway insert a Row and Column which have the Letter reference (Col) and Number Ref (Row).

    e.g.

    =indirect("'[eg formulas.xls]Time and Date Formulas'!"&B$1&$A2)

    where the inserted row contains B, C, D etc.
    and the column 1, 2, 3 etc.

    Hope this helps, I can email a small eg if you need it.
    "Have a good time......all the time"
    Ian Mac

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for this Ian,

    I'll give it a go and if I need to I'll ask you to send an example,

    Cheers,

    Mike

Some videos you may like

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
  •