Check if value is included / exists in range of cells - Excel

How can I check if the value from one cell exists in the specific range of Excel cells ?

Hi,

To check if value exists in the range of cells, you can use combination of IF and COUNTIF functions. Example of formula can be:

=IF(COUNTIF(A5:A15,B5),"Value is included","Value is not included")