Cell to Range Compare with Text String Output

Hi, request for help please. I need a formula that will compare the entry in a cell (A1) to the entries in a defined range (A2:A101), and if there is a match with any cell in the defined range provi...

excel

Formulas and Functions

OliverScheurich
Apr 23, 2023
Tolley123
=IF(SUM(N(ISNUMBER(SEARCH(A1,A2:A6))))>0,"yes","no")
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

OliverScheurich

Gold Contributor

Apr 23, 2023

Tolley123

=IF(SUM(N(ISNUMBER(SEARCH(A1,A2:A6))))>0,"yes","no")

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

Tolley123
Copper Contributor
Apr 23, 2023
That works great. Thank you QP!

Forum Discussion

Cell to Range Compare with Text String Output

Resources