title: Recreating a Google Spreadsheets QUERY() in Excel
body: <p>I have a massive Excel Workbook that I use for tracking product titles and descriptions, and I'm trying to get it to generate .csv files for importing those products into eBay and my own website. I'm 99% of the way there, but I can't seem to find the Excel equivalent of Google Spreadsheet's QUERY() function, and there are two spots I need to use it:</p>
  
  <p>1st, I need to populate a column in SheetB with the Product IDs in SheetA that have not been listed on the site. In Google Spreadsheets, I would do this with <code>=query('SheetA'A:B,"select A where isblank(B)")</code> but I can't for the life of me figure out the equivalent in Excel.</p>
  
  <p>2nd, I need to take all the non-blank rows from four different sheets and put them together into one sheet. </p>
  
  <p>There has to be something obvious I'm missing, but I'm missing it. Help me, magical internet people, you're my only hope!</p>