title: Address Formula in Google Sheet
body: <p>I am new to Excel and need help in resolving below error</p>
  
  <p>=ADDRESS('18/05/2020'!B86&amp;":"&amp;ADDRESS(MATCH("Debtors Total",'18/05/2020'!G:G,0), COLUMN(G2)))</p>
  
  <p>I need to keep my range dynamic. The Range should be from B86 to Column G wherever cell value is Debtors Total.</p>
  
  <p>So Ideally it should return ('18/05/2020'!B86:G98)</p>
  
  <p>Please help.</p>
  
  <p>Thanks</p>