I have a category. Let's call it fruits. The category fruits includes: bananas, apples, oranges, grapes.

In a separate sheet, I have a list of text cells with corresponding values. Example:


C5____D5____E5_____F5___G5______H5
Apples__3____Steak___2___Oranges__4

So, Apples corresponds with 3
Steak corresponds with 2
Oranges corresponds with 4


I want to take the lowest value of a fruit. Since steak is not a fruit, the return I want is "3." Any ideas?


Thank you very much!