I'm using Microsoft Office for Mac 2011 and I'm simply trying to find if a value from one list is in another list. In this case I want to see if MM33 (A2) from list A is in List B. I've tried using a column array, a range, and cell specific formulas. The column array and range does not find...