title: Dynamic cell reference in Google Sheets
body: <p><a href="https://i.stack.imgur.com/uHiLq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uHiLq.png" alt="enter image description here"></a></p>
  
  <p>I want to get the salary of Evan. This code is working perfect:</p>
  
  <pre><code>=vlookup("Evan",{A2:A,D2:D},2,0)
  &gt;&gt; will output 44444
  </code></pre>
  
  <p>But how to make the cell reference dynamic? so in <strong>=vlookup("Evan",{A2:A,D2:D},2,0)</strong> , i want to make the <strong>'D'</strong> dynamic. Let assume, this is a big table where we don't know the position of the  'salary' column, so there will be inserting new column (or delete column) to the left of 'salary' column which will push the salary column to left or right. One thing to be sure there's only unique 'salary' header title on the first row,  let's assume we have no idea where that column so we will chase it by that 'salary' string.</p>
  
  <p>So the question: how to make the code, so the cell reference to the 'salary' column will not be broken.</p>