Excel

[PHBExcelQs]

I want to match a value in a cell to a value within a column using an if then statement.  Example -

If cell A1 = a value within the column B1 through B25, then the value for C1 = "Yes"

What would my formula look like to accomplish this?

[#2]

@PHBExcelQs Hi. You can use

=IF(ISERROR(MATCH(A1;B1:B25;0));"";"Yes")

[#3 · Accepted solution]

@PHBExcelQs 

That could be

=IF( COUNTIF( $B$1:$B$25, A1 ), "Yes", "No" )

[#4]

@PHBExcelQs 

=IF(COUNT(SEARCH(A1,$B$1:$B$25))>0,"yes","no")

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. 

[#5]

@Sergei Baklan 

Your formula worked.  Thank you.

[#6]

@PHBExcelQs , you are welcome