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
Find us on Facebook AnswertabsFind us on Facebook Answertabs
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 twitter
2021 AnswerTabsTermsContact us