Finding a specific text string throughout an entire column and if there return true/false

[myfivemonkeys]

I'm trying to search for instances of the partial text strings from tab A (Sample string to look for) in tab B (Data to Search). I've used the FIND function but I can't get the logic right to search the entire column in tab b.

Anyone?

[daffodil11]

Using ISNUMBER(FIND()) is returning an array of answers. Instead I'd use ISNUMBER(MATCH()) to find if it is in one of them.

Also, it's a good practice to declare row numbers in your ranges as you're otherwise searching all 1.04MM rows. While not much of an issue with a few formulas, you'll notice significant performance degradation with more than a few dozen of them.

=ISNUMBER(MATCH("*"&A2&"*",'data to search'!$A$2:$A$52,0))

If you insist on using your original logic, you could instead encapsulate the formula with SUMPRODUCT and test if >0.

=SUMPRODUCT(--ISNUMBER(SEARCH(A2,'data to search'!$A$2:$A$52)))>0

[martindwilson]

try
=ISNUMBER(MATCH("*"&A2&"*",'data to search'!A:A,0))

[AlKey]

Try this

=ISNUMBER(LOOKUP(25^25,SEARCH(A2,'data to search'!$A$2:$A$52)))

Row\Col	A	B
1	Chassis Name (adjusted)	PRP-3 ?
2	pip-bb10-akr	FALSE
3	pip-bb10-ana	FALSE
4	pip-rr2-chi	TRUE
5	pip-rr2-fw	FALSE
6	pip-rr2-pen	FALSE
7	pip-rr2-sj	TRUE
8	sl-bb20-ams	FALSE
9	sl-dr10-dal	FALSE
10	sl-dr11-dal	FALSE
11	sl-gw1-pen	FALSE
12	sl-pe10-akr	TRUE
13	sl-pe10-albrm	FALSE
14	sl-rr10-lon	TRUE
15	sl-rr11-par.sprintlink.net	TRUE

[myfivemonkeys]

Thanks - Daffodil11 and Martindwilson! it worked!

[daffodil11]

Hurray! Klondike bars for everyone!

[Tony Valko]

Hurray! Klondike bars for everyone!

Over here in Hooterville it's a bit brisk. How about a nice steaming hot bowl of chili?