title: Advanced Excel Help - Lookup Formula
body: <p>I've tried index match and xlookup to no avail.  I don't use offset much, and not sure if that's the fix either.  I can't share the spreadsheet because it has sensitive data, but I'll provide the screen shots and the formula that is currently used here.</p>
  <p><a href="https://i.stack.imgur.com/Nh6sD.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nh6sD.jpg" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/3m9X8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3m9X8.jpg" alt="enter image description here" /></a></p>
  <pre><code>=XLOOKUP(BI$2,answers!$E:$E,XLOOKUP(testers!$A543,answers!$B:$B,answers!$F:$F))
  </code></pre>
  <p>excel-lookup-formula
  testers worksheet:
  I'm trying to pull the 'response' provided by user ID (col A) to a specific question (Row 2)</p>
  <p>excel-lookup-table
  answers worksheet
  User IDs (Col B)
  Question # (Col E)
  Response (Col F)</p>