title: Formula to search a range/array in Sheet2 for values in Sheet1 and return values found in Sheet2 but not in Sheet1?
body: <p>I have three sheets. Sheet1 contains a column of data (player names), Sheet2 contains an array of player names associated with each other, and Sheet3 is currently blank. I'd like to figure out what formula to use in Sheet3 to search the array in Sheet2 for all names <em>not</em> in the column in Sheet1, and then return those in Column A in Sheet 3. Names in the array may be redundant, if that matters. </p>
  
  <p>I'm unsure of the formula to employ; Index/Match doesn't seem to fit the bill, and neither does VLookup.</p>