title: Using VBA to output a value in a column given a certain input
body: <p>Here's what I would like to do:</p>
  
  <p>I have a list of values in a column. I would like VBA to read that column, and than output values into a new column based on conditions I give it. For example, if the value in column A is between 1 and 2, I would like the value in column b to be 6, if the value is between 2 and 3, I would like the value in column b to be 20. </p>
  
  <p>Thanks!</p>