title: Excel If Statement Referencing another Sheet
body: <p>I have Sheet1 named "Suppliers" and Sheet2 is named "Online Order". Suppliers has a list of suppliers we use at work and some of them have to be ordered online. Sheet 2 is meant to have the login info to make the order. Suppliers has ColumnD say Yes or No if it's an online order while ColumnA is the list of suppliers.  </p>
  
  <p>I want Online Order to only have those supplier names on it. Basically, IF Suppliers ColumnD says Yes, Online Order ColumnA is filled with Supplier ColumnA of only the lines that have a Yes in ColumnD. </p>
  
  <p><a href="https://i.stack.imgur.com/kezbL.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p><a href="https://i.stack.imgur.com/Zeze2.png" rel="nofollow noreferrer">enter image description here</a></p>