title: Return a value from another column and sheet using MATCH
body: <p>I have a worksheet where I need to fill in data referenced from other worksheets.</p>
  
  <p>I need to match a value on my main sheet with one on another sheet and once the cell has been found I need to get the value of a different cell offset by 1 row up and 5 columns left. I know which columns I need but I need MATCH to return the initial row.</p>
  
  <p>MATCH will give me the initial row that I need.<br >
  ADDRESS means I can build the cell reference.<br >
  OFFSET allows me to reference another cell if I have the original cell address.</p>
  
  <p>However the ADDRESS function will only return the address as a text string and not as a reference that can be used in the OFFSET formula.</p>
  
  <p>Does anyone know of a way to make this work?</p>
  
  <p>Kind regards</p>
  
  <p>Matt</p>