Search a specific value within a range
Hi, in this example, I would like to search a value (each cell in Column 5), within a range in Column4. I tried using formula HAS and CONTAINS, but it seems the criteria or search value is not recognized when I click on a cell in Column 5.
Appreciate if you can help me to find a way to pull this off.
Help Article Resources
Check out the Formula Handbook template!