Using Indirect function inside the Search function

**skhari** · 08-20-2014, 04:57 PM

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"))))

**Jamie.Reis** · 08-20-2014, 04:59 PM

Remove any/all NPI and post the example.

**skhari** · 08-20-2014, 05:30 PM

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

**XOR LX** · 08-20-2014, 05:31 PM

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

**skhari** · 08-20-2014, 05:32 PM

Kindly refer the attachment (attached now)

Using Indirect function inside the Search function

LinkBack

Thread Tools

Rate This Thread

Display

Using Indirect function inside the Search function

Re: Using Indirect function inside the Search function

Re: Using Indirect function inside the Search function

Re: Using Indirect function inside the Search function

Re: Using Indirect function inside the Search function

Thread Information

Users Browsing this Thread

Similar Threads

INDIRECT function not working inside MATCH with dynamic ranges

INDIRECT inside a LINEST function

search inside a date function

[SOLVED] LOOKUP function with SEARCH and INDIRECT

[SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions