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" )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 10, 2022

PHBExcelQs 

That could be

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

Resources