title: Can I use match() with offset() in Excel?
body: <p>I'm using <code>match()</code> to locate a cell with a specific value in column A.</p>
  
  <p><code>=MATCH("Sales",A:A,0)</code></p>
  
  <p>This returns the row value <code>40</code> for example.</p>
  
  <p>I want to then use this value with <code>OFFSET()</code> like so:</p>
  
  <p><code>=OFFSET(MATCH("Sales",A:A,0),1,1)</code></p>
  
  <p>So if my <code>match()</code> returned A40, <code>offset()</code> would then give me the value of B41. Unfortunately, this does not work. What can I do to achieve this?</p>