title: Reference a range using column number
body: <p>I'm looking for something rather simple, but I've been trying to do it for quite some time now. I need to get values from a column.</p>
  
  <p>Lets say I have several columns with headers and I need to pull data from a column with a specific header. I can easily get it's number by using <strong>MATCH</strong> to look through the row with headers. Now that I have number - I need to pull say 10 cells from this column right below the header.</p>
  
  <p>For example if headers are in the first row and the one I need is in the <strong>E</strong> column then I need to pull <strong>E2:E11</strong>. And I have <strong>5</strong> as the column number resulting from <strong>MATCH</strong> function. I would use <strong>OFFSET</strong> as it does pretty much what I need with values like this <strong>OFFSET(A1;1;MATCH(blablabla);10;1)</strong>. And it works just fine, however I need to do this from a closed workbook and <strong>OFFSET</strong> only works with currently opened ones.</p>
  
  <p>There's got to be a simple solution, I can't believe Excel provides a function like <strong>COLUMN</strong> but not the reversed solution. For the sake of people using the resulting workbook I can't really switch to <strong>R1C1</strong> view but if that would be my only option, I guess that will have to do.</p>
  
  <p>Please advice what I could do in this situation.</p>