Forum Discussion
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 my formula look like to accomplish this?
5 Replies
=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.
Your formula worked. Thank you.
PHBExcelQs , you are welcome
