title: Excel - Selecting cell based on other column values
body: <p>I am trying to select the correct cell based on the values of adjacent columns. For example -</p>
  
  <p>Sheet 2 - This acts as a database of sorts holding all data/values<br>
  <a href="https://i.stack.imgur.com/qheXz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qheXz.png" alt="Sheet 2"></a></p>
  
  <p>Sheet 1 - The "Result" should populate with the "Item" from Sheet 2. The filter criteria is "Value" needs to be less than or equal to (&lt;=) "Rating" and for multiple matches select the lowest "Sell" item. So, Item 3 has a value of 650 which means the applicable Items from Sheet 2 are G,H,J,K,L,M however the "Result" is populated with "G" because that has the cheapest "Sell" value.<br>
  <a href="https://i.stack.imgur.com/r6H2H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r6H2H.png" alt="Sheet 1"></a></p>
  
  <p>How can I write this for all "Result" cells? I am not well versed in Excel but I do know how to query a database such as MySQL, if that helps.</p>
  
  <p>Thank you!</p>