title: How do I apply a formula in a whole column based off of multiple conditions?
body: <p>I have an Excel file where data is kept for monthly expenses with supply orders for co-workers. If a co-worker needs a <code>Head set</code> let's say, it is put into an Excel sheet with a dollar amount of how much it costs. I want to make it automated so if you enter <code>Head set</code> in one cell the dollar amount automatically comes up in the "Total Cost" cell. The problem being that there are multiple items that can be ordered. </p>
  
  <p>I've come up with what I think could be a start but not sure how to implement it. I'm looking for guidance and any suggestions on what to do here. </p>
  
  <p>Column M contains the "supply input" such as <code>Head set</code>, <code>lumbar support</code>, etc.<br>
  Column K contains the "total cost".</p>
  
  <pre><code>IF (M16 = Foot Rest, "$20.48","-")
  </code></pre>
  
  <p>However Column M could also contain <code>Foot Rest</code>, and <code>Head set</code> so that's what's tripping me up. I would like to think that it would contain an extended ELSEIF statement on the above IF statement but I'm unsure how that would work. </p>