CODEWITHSUNDEEP
excel
Victor Antifries
Victor Antifries

Reputation: 55

Excel - Check if column has specific text

I went to this site. It says the answer is this: 

=ISNUMBER(SEARCH(substring,text))

I need it to check a column so I tried: 

=ISNUMBER(SEARCH(C5,B5:B25))

but of course this doesn't work.

I also tried another article from the same site, but I have no idea how to present the range.

Upvotes: 0

Views: 1066

Answers (1)

Scott Craner
Scott Craner

Reputation: 152465

Use MATCH instead of SEARCH()

MATCH whole cell:

=ISNUMBER(MATCH(C5,B5:B25,0))

MATCH part of cell:

=ISNUMBER(MATCH("*"&C5&"*",B5:B25,0))

Upvotes: 2

Related Questions