title: How can I return a lookup value from a third column from a reference value in two cells?
body: <p>I have an excel file with two sheets. I'm trying to reference one sheet's numbers based on text using a formula in the other sheet. I have one sheet that looks something like this -</p>
  
  <p><img src="https://i.stack.imgur.com/nK2WH.png" alt="Sheet 1"></p>
  
  <p>And another that looks like this -</p>
  
  <p><img src="https://i.stack.imgur.com/7u6Ag.png" alt="Sheet 2"></p>
  
  <p>I would like to put a formula on the first sheet that basically says - look on the second sheet for the values in columns A and B and return me the value in column C. The tricky part is - the values in the first sheet may be inverted or there may be an instance where only one value is present, like in row 1 in the first sheet. Also the formula should only fill in a value if both columns match. All text combinations in Sheet 2 are unique.</p>
  
  <p>So for example - on the first sheet the formula should return 1 in cell C1, 5 in cell C4, and would error in the other 2 cells.</p>
  
  <p>I hope that wasn't too confusing. I would greatly appreciate any help you can give.</p>
  
  <p>Thank you!</p>