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 ?
08 Feb 2021 at 05:43 PM
0pnshow more
NicoleNicole
Follow us on find us on facebook follow us on twitter
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")
09 Feb 2021 at 11:15 AM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
2021 AnswerTabsTermsContact us