title: Excel Match to Table Header from three criteria
body: <p>I am trying pull a rank value (UN, NI, AE, HE, EX) from table headers, when individual score is compared to the table of goals. The Match criteria must include level and quarter, as the goals increase each quarter and goal ranges are different per individual's level.</p>
  <p>I have tried xlookup, but I cant get it to work has #value! error</p>
  <pre><code>=XLOOKUP(B2&amp;E2&amp;D3,Goals[[ Level]]&amp;Goals[Quarter]&amp;Goals[[UN]:[EX]],Goals[[#Headers],[UN]:[EX]])
  </code></pre>
  <p>I have tried index match combination, but could not figure out a proper formula for the 3 criteria. I did not get it to work, and I did not get it to include a 3rd match criteria either.</p>
  <pre><code>=INDEX(Goals[[#Headers],[UN]:[EX]],,MATCH(D3,INDEX(B8:F11,MATCH(B2,A8:A11,0),,),-1),) 
  </code></pre>
  <p>The goal is to fill in cell B4 with the equivalent ranking value which equates to the the headers in cells B7:F7. If person's score is equal to or greater than a level and quarter goal then they should get a ranking matching that column's header as long as it is not greater than the next column's goal.</p>
  <p><a href="https://i.stack.imgur.com/Rr2Xk.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rr2Xk.jpg" alt="enter image description here" /></a></p>