title: Dynamic Formulas
body: <p>I have a sheet called <strong>Column Reo</strong> on this sheet is a whole lot of data entry because on concrete column properties... </p>
  
  <p>Eg: </p>
  
  <ol>
  <li>width </li>
  <li>depth </li>
  <li>height </li>
  <li>no. of vertical reinforcement bars </li>
  <li>dia of bars</li>
  </ol>
  
  <p>I also have a second sheet that has <strong>fixed data</strong> for some named rages etc on it... </p>
  
  <p>Eg: </p>
  
  <ol>
  <li>width </li>
  <li>constants of reinforcement bars</li>
  <li>ligature pattern type calcs</li>
  </ol>
  
  <p>etc.</p>
  
  <p>Each lig pattern needs a different formula based on shape of column and columns structural loading etc. There are 27 different lig pattern types.</p>
  
  <p>I have written formulas on the "fixed data" sheet that would calculate the total length of each lig pattern based on the concrete columns properties and then created a drop down menu on the "column reo" sheet that uses <strong>VLOOKUP</strong> to match that up, problem is I want to drag across the actual formula so that it dynamically adjusts to the row that it's been copied to and uses the data from that row to calculate the total lig length. </p>
  
  <p>I hope that explains it properly, I am hoping it can be done without VBA but if that is needed, so be it! </p>
  
  <p><strong>EDIT</strong>
  Here is a link for the file <a href="https://www.dropbox.com/s/c29e0s4g13cr89p/Reo%20calculation%20sheet.xlsx" rel="nofollow">https://www.dropbox.com/s/c29e0s4g13cr89p/Reo%20calculation%20sheet.xlsx</a></p>
  
  <p>Based on the selection from "column reo"-H4 drop down menu I want to be able to pull across the formula from "fixed data" corresponding table. But I need the formula to adjust for the row that it is on. </p>