title: Excel lookup value if found, get another value, if yes, return another value
body: <p>I have a mapping table below which is used for check the value</p>
  
  <p><a href="https://i.stack.imgur.com/KR0NW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KR0NW.jpg" alt="enter image description here"></a></p>
  
  <p>Below picture is the result</p>
  
  <p><a href="https://i.stack.imgur.com/5iD5W.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5iD5W.jpg" alt="enter image description here"></a></p>
  
  <p>First I need to search the key in the mapping table, if not found, input "No" in Value column, if found, check the Code column, if the value "No", return "Z1" to Value column.
  I know how to use index match to return "No" value but I don't know how to check it is yes or no. Becasue if yes, I need to return another value which is "Z5".</p>
  
  <p>Thanks...</p>