Forum Discussion

PHBExcelQs's avatar
PHBExcelQs
Copper Contributor
Apr 10, 2022
Solved

Excel

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 m...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 10, 2022

    PHBExcelQs 

    That could be

    =IF( COUNTIF( $B$1:$B$25, A1 ), "Yes", "No" )
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 10, 2022

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. 

Resources