+ Reply to Thread
Results 1 to 5 of 5

Using Indirect function inside the Search function

  1. #1
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    177

    Using Indirect function inside the Search function

    Dear Experts

    Kindly review this below formula and please let me know what's gone wrong.The same formula is working fine in some sheet but not in all sheet. Please guide me (all sheet consist of same kind of value)

    =IF($H5="","",SUMPRODUCT((ISNUMBER(SEARCH(INDIRECT("'"&$A$1&"'!"&"$H5"),INDIRECT("'"&$A$1&"'!"&"$C$4:$C$2000"))))*(INDIRECT("'"&$A$1&"'!"&"$A$4:$A$2000")=J$3)*(INDIRECT("'"&$A$1&"'!"&"$D$4:$D$2000"))))
    Attached Files Attached Files
    Last edited by skhari; 08-20-2014 at 05:28 PM. Reason: Added the Example Excel File

  2. #2
    Registered User
    Join Date
    08-19-2014
    Location
    Pittsburgh, Pennsylvania
    MS-Off Ver
    2010
    Posts
    45

    Re: Using Indirect function inside the Search function

    Remove any/all NPI and post the example.

  3. #3
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    177

    Re: Using Indirect function inside the Search function

    Thanks for your response. Now i have added the example excel file

  4. #4
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Using Indirect function inside the Search function

    Hi,

    Not sure I understand. In which sheets/cells precisely is the issue we're supposed to be looking at? What should the results be, and why?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  5. #5
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    177

    Re: Using Indirect function inside the Search function

    Kindly refer the attachment (attached now)

+ 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 function not working inside MATCH with dynamic ranges
    By fotografer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:09 AM
  2. INDIRECT inside a LINEST function
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-24-2013, 12:06 PM
  3. search inside a date function
    By davebue in forum Excel General
    Replies: 2
    Last Post: 07-18-2013, 10:14 AM
  4. [SOLVED] LOOKUP function with SEARCH and INDIRECT
    By bubbacheese in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-13-2013, 03:55 PM
  5. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 PM

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