title: Excel - Formula to cross-check two inventories
body: <p>I am trying to build a formula to check between two inventory lists to ensure a given serial # is on both lists. I suspect a nested VLOOKUP is necessary but I cannot figure out how to construct the formula. Here is the setup:</p>
  
  <p>Sheet1= Warehouse_1...contains a list of serial numbers (all in Warehouse 1)</p>
  
  <p>Sheet2 = Master_Inventory...contains two columns: (A) Serial #s, (B) Location (dropdown: Ware1, Ware2, etc.)</p>
  
  <p>I am seeking to add a third column in Sheet2 with a formula that says:</p>
  
  <ol>
  <li><p>If Location=Ware1, check the corresponding Serial # in Column A against the Warehouse_1(Sheet1) list.</p>
  
  <ul>
  <li>If found in Sheet1 list, return 'check mark'</li>
  <li>If not found in Sheet1 list, return 'x mark'</li>
  </ul></li>
  <li><p>If Location is NOT Ware1, leave blank</p></li>
  </ol>
  
  <p>I would also like to maintain the ability to sort Sheet2 by Serial # and Location, meaning I don't want the formula to move with the entries as they are sorted.</p>
  
  <p>Any help or ideas are greatly appreciated!</p>