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
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
Follow us on Facebook & Twitter
2022 AnswerTabsTermsContact us