Excel Forum

Lookup Mutliple strings?

KENNETH BATILO

Member

Members

Forum Posts: 27

Member Since:
January 30, 2020

Offline

April 22, 2022 - 4:53 am

Not sure if I'm asking correctly, but... this is what I need to do (an example)

I have a user that wants to find a school with the words "western" "university" in them. (wildcard search basically). And I want the results to be below.

	Search	Results
School Name	Western University	School1, School2, School4, School7

The data source is below

School1	Northwestern University
School2	Junior University
School3	Junior College
School4	My University
School5	That College
School6	This College
School7	Western College

Is this even possible?

Thanks in advance!

Mynda Treacy

Admin

Forum Posts: 4449

Member Since:
July 16, 2010

Offline

April 22, 2022 - 3:03 pm

Hi Kenneth,

If you have Microsoft 365 you can use this formula:

=TEXTJOIN(", ",TRUE,FILTER(A4:A10,(ISNUMBER(SEARCH(B1,B4:B10))+ISNUMBER(SEARCH(B2,B4:B10)))))

See file attached.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Richard West, Wesley Burchnall, Clayton Watson

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27291

Member Stats:

Guest Posters: 49

Members: 31913

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen