title: Unable to extend VLOOKUP formula
body: <p>A quick question on VLOOKUP.</p>
  
  <p>I have two sheets ("Sheet2" acting as source or list of elements and "Sheet1" is where the VLOOKUP formula will be used)</p>
  
  <p><img src="https://i.stack.imgur.com/dirdH.png" alt="enter image description here">
  <img src="https://i.stack.imgur.com/qYoqU.png" alt="enter image description here"></p>
  
  <p>I have created a name so that I can reuse the vlookup formula for A2 (Sheet1) also.</p>
  
  <p><img src="https://i.stack.imgur.com/eFT9X.png" alt="enter image description here"></p>
  
  <p>The issue is when I drag the formula to B2 in Sheet1 (where I want the VLOOKUP to be applied) it is showing me error and upon inspection I found that the variable I created "qw" is dynamically changing for every row.</p>
  
  <p>See below :</p>
  
  <p><img src="https://i.stack.imgur.com/vZJln.png" alt="enter image description here"></p>
  
  <p>QUESTION :</p>
  
  <p>Can someone tell me how to apply VLOOKUP formula to B2 in Sheet1 ?.</p>