title: How to make a range absolute with offset functions in excel?
body: <p>I have defined a dynamic range using OFFSET function in Excel, and I use it in VLOOKUP function to lookup a value:</p>
  
  <p><img src="https://i.stack.imgur.com/2Rc96.png" alt="enter image description here"></p>
  
  <pre><code>=VLOOKUP($B6,OFFSET(C30,0,C4):OFFSET(C36,0,C4),2,0)
  </code></pre>
  
  <p>Problem is the range is not absolute, and it cannot lookup the value. If I hadn't used OFFSET function, I would define the range as follows, which would work:</p>
  
  <pre><code>=VLOOKUP($B6,$C$30:$C$36,2,0)
  </code></pre>
  
  <p>How can I make the following function's range absolute as above, so that the values can be looked up?</p>
  
  <pre><code> =VLOOKUP($B6,OFFSET(C30,0,C4):OFFSET(C36,0,C4),2,0)
  </code></pre>