title: Multiple criteria-based vlookup on google Sheets?
body: <p>Can anyone point me towards how to do a multiple criteria text-based vlookup on Google Sheets?</p>
  
  <p>I have columns that read CATEGORY, STUDENT NAME, SCORE. How can I get the SCORE if the CATEGORY is 'Creativity' and the STUDENT is 'xxx'? (The data isn't sorted and the first result found is fine!)</p>
  
  <p>This seems like it should be really easy, but I can't see any solutions on here.</p>
  
  <p>Thanks</p>
  
  <p>Tardy</p>