Trying to understand how SEARCH work

Status
Not open for further replies.

szakharov7723

Board Regular
Joined
Jun 22, 2018
Messages
85
Office Version
2019
Platform
Windows
So I use the same database, the same cell, same formula. But somehow I get different behavior of formula when I evaluate it.
Here I use SEARCH as a single formula
Code:
{=SEARCH(List,E521)}
And I get only first item from the List (table).

But here I use SEARCH in combination of formula
Code:
{=INDEX(List,SUMPRODUCT(ISNUMBER([U]SEARCH(List,E521)[/U])*(ROW(List)-1)))}
And I actually get all items from the List.

What makes it change the behavior ?
 
Last edited:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,853
Office Version
365
Platform
Windows
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,089,935
Messages
5,411,351
Members
403,362
Latest member
DoubleJay

This Week's Hot Topics

Top