title: excel - dynamic searching and matching
body: <p>I wondered if you could help with the below problem. Apologies for the data format</p>
  <p>This is the dataset I have:</p>
  <p>First tab is called Compliance</p>
  <p><a href="https://i.stack.imgur.com/ttDJm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ttDJm.png" alt="" /></a></p>
  <p>and Second tab is called Operations</p>
  <p><a href="https://i.stack.imgur.com/lo07h.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lo07h.png" alt="" /></a></p>
  <p>Basically, for the Compliance tab, I would like to return the Risk No in the Operations tab if the following conditions are met:</p>
  <ol>
  <li>the name as per Column D is the same and</li>
  <li>the name in Column E and Column F are the same</li>
  </ol>