Mac Numbers: How to identify cells that match a range of cells from another table?
You can use the Match() function to check if a value exists in at least one cell within a certain range of cells.
Pls let us know if the information provided at the Apple Support page for this function is not enough for you or if you have any other questions. In such a case, it might be better if you also provide screenshot(s) of your data and what you want to eventually achieve (you may just do it manually as an example if necessary).