title: IF formula comparing a range
body: <p>I need a formula that will take the value in A2 and match it to the range of B.  If there is a match then the result should be the corresponding value in column C.</p>
  
  <p>So in this scenario the result should be Red1:</p>
  
  <p><a href="https://i.stack.imgur.com/ZgwvY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZgwvY.jpg" alt="[Excel color sheet"></a></p>