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") | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |