Trying to understand how SEARCH work

Status
Not open for further replies.

szakharov7723

Board Regular
Joined
Jun 22, 2018
Messages
65
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:

Fluff

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

Forum statistics

Threads
1,077,851
Messages
5,336,750
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top