title: How to extract data in Microsoft excel that satisfies certain criteria
body: <p>The question I have is kind of confusing, so I am going to give a little background on the particular task I'm working on so you can have a better understanding. In one of the spreadsheets I am working on (Called the Fixture Mix Template), I have a list with a bunch of fixture components that are identified by their respective codes (the company calls them oracle codes), which are listed in Column G. Out of these components, some are categorized as "main components" and if they are a main components, they will have their oracle codes in Column E within their respective rows. For the components that aren't "main components" I just left their cells blank in this column. On a separte worksheet (Called the SUmmary Tab), I have a table that lists the main component codes with the costs that it takes to make and assmeble them. The question I was wondering is if anyone knows a particular formula I could use where if a component on the Fixture Mix Template tab is identified as a main component, then it would autopopulate the table on sheet 2 in the cells where someone would have to enter in the main component oracle code. I hope this makes sense! </p>
  
  <p>I will also show you a picture to give a better understanding as well. 
  <a href="https://imgur.com/2Gk6CVU" rel="nofollow noreferrer">http://imgur.com/2Gk6CVU</a> (this worksheet is called the Fixture Mix Template). My main question is if anyone knows a way where I could extract only the cells that have an oracle code in column E of that worksheet into column A of this picture <a href="https://imgur.com/gh00vIE" rel="nofollow noreferrer">http://imgur.com/gh00vIE</a> (This is another tab in my workbook called the Summary tab)</p>
  
  <p>IMAGES Posted</p>
  
  <p>First Image:<img src="https://i.stack.imgur.com/v2d90.jpg" alt="enter image description here">
  Second Image:<img src="https://i.stack.imgur.com/LKQ34.jpg" alt="enter image description here"></p>