+ Reply to Thread
Results 1 to 3 of 3

Replacement to INDIRECT

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    22

    Replacement to INDIRECT

    Dear All,
    I am currently using INDIRECT formula in my excel sheet, which make all other excel workbook slow.

    To replace INDIRECT i need your help to understand how the color name in "Allocation V1.xlsx'!GRAY" can alone be changed dynamically based on the value in another cell. Say for example if the cell value is RED then i need to refer "Allocation V1.xlsx'!RED"

    Basically i will use "PAN India Allocation ver1.xlsx'!GRAY" inside SUMIFS formula.

    Kindly help. Thank You

    Regards
    Krish

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Replacement to INDIRECT

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Replacement to INDIRECT

    without sample file difficult guide to you. Best way attach sample with dummy data record with actual before & after data.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. INDIRECT replacement for closed workbook?
    By Marco-Kun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2014, 10:54 AM
  2. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  3. [SOLVED] Non-volatile replacement for INDIRECT in SUMIFS formula
    By Lotrking1010 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2013, 11:06 AM
  4. Replacement of Indirect Function for Variable Size Range
    By Andrew Blundon in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-01-2013, 08:55 AM
  5. Sum of indirect sheet names with multiple cells (SUM, INDIRECT,SHEETNAME in cell)
    By a1b2c3d4e5f6g7h8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2013, 08:42 AM
  6. Replacement for using Indirect (Volatile)
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-31-2009, 09:54 AM
  7. Replies: 2
    Last Post: 04-25-2009, 06:36 AM

Tags for this Thread

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