title: Auto populate Excel field based on Drop down value in another column
body: <p>I have an excel sheet with few columns. One of the columns is a drop down based on a handful of values that I added. However, For each drop down value there is a matching account number which I would like auto populated once the drop down value is selected. Column D has the drop down and the drop down values and accounts are in BR5: BS38 and Would like the account to be populated in column E automatically everytime a drop down values is chosen.</p>
  
  <p>Code I am using, however, it doesnt populate automatically, I have to copy the formula down and when I copy it down, if nothing is chosen in the drop down it will se #N/A.</p>
  
  <pre><code>=VLOOKUP(D5:D38,$BR$3:$BS$38,2,0)
  </code></pre>