+ Reply to Thread
Results 1 to 3 of 3

Indirect Formula Issue

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Indirect Formula Issue

    I have a workbook called profit2021.xls


    I am trying to combine the indirect function to refer to the value on sheet which I have listed in E1

    I get a message there is a problem with this formula


    It would be appreciated if someone could kindly amend my formula



     ="[profit2021.xls"&indirect("'"&e1"'"&"!"&"$C$520")

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Indirect Formula Issue

    =INDIRECT("[profit2021.xlsx]"&E1&"!"&"$C$520")
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Re: Indirect Formula Issue

    Thanks for the help. Formula works perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 08-17-2016, 04:06 PM
  2. [SOLVED] VBA Formula SUMIF with INDIRECT performance issue
    By ffasan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-02-2014, 08:33 AM
  3. Indirect Sum between two tabs issue
    By cloakedgerb in forum Excel General
    Replies: 7
    Last Post: 03-14-2014, 07:01 PM
  4. [SOLVED] tricky puzzle - sum and indirect formula issue
    By garyxprice in forum Excel General
    Replies: 5
    Last Post: 10-07-2012, 04:52 PM
  5. [SOLVED] Applying the INDIRECT or INDEX function on formula to solve #REF issue
    By Flight777 in forum Excel General
    Replies: 23
    Last Post: 05-24-2012, 09:23 AM
  6. Indirect Issue
    By ruperupe in forum Excel General
    Replies: 2
    Last Post: 04-23-2012, 03:57 PM
  7. Indirect issue
    By MickeyP in forum Excel General
    Replies: 2
    Last Post: 02-19-2008, 02:29 PM

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