Excel formula to check if a value is present in a column

Excel formula to check if a value is present in a column pictures 5