title: Searching a Value across an entire spreadsheet
body: <p>I have an excel spreadsheet and in one column (lets call it org numbers) of one sheet i have a list of values.  On another tab i have these values scattered between A1:AX281.</p>
  
  <p>I am trying to do a match/lookup/count to ensure the positions i have between A1:AX281 match the values i have in the org numbers sheet.  I have searched this for a while now and haven't found something to an exact match.  i have tried using certain formulas but i wonder if merged cells and formulas in these cells affect my result?</p>