title: Conditional Copying in Excel
body: <p>I have the following problem which I can't seem to solve.
  I have an inventory workbook with an order number listed as columns and types of products listed as rows. Beneath the order number, I have also specified the Shipping date and name of the customer. 
  I want to make an automated shipping note sheet which is linked to this inventory sheet. </p>
  
  <p>Here I want to be able to specify the order number so that the corresponding column with the amounts of each product is returned to the shipping note sheet. I was thinking of the formula (in cell C6 which specifies the amount ordered of the first product) <code>=IF($B$4=Outbound!E$4$, Outbound!E7, 0)</code></p>
  
  <p>Here B4 is the input field for the order number, E4 is the order number cell for the first order (named for example A13001) and E7 is the corresponding amount of the first product from the first order in the Inventory sheet. When I copy this downwards it does return the amounts for the first order. However, what I want is when I change the order number input field (B4) into for example A13002, that the amounts of the products in the shipping note sheet change as well (so the second column of the inventory sheet instead of the first column corresponding to A13001). Which formula should I use and how?</p>
  
  <p>Can someone please help me?</p>