title: Excel formula to return value if two conditions are matched
body: <p>I need a formula that can be pasted into cells <code>B2:D5</code> in the sheet displayed in the image below. The formula should see if the value for the row in column <code>A</code> matches a color in row <code>G</code> and if the value for the column in row <code>1</code> matches a animal in row <code>H</code>. For all cells without a two part match it should return a blank <code>&quot;&quot;</code>. If there is a two way match then it returns the numerical value in column <code>I</code></p>
  <p><a href="https://i.stack.imgur.com/016pZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/016pZ.png" alt="enter image description here" /></a></p>