I have another formula question similar to my previous post.

Now I would like to create a formula in one cell that would produce the
lowest amount given in a range. For example:

Column A Column B
Apples $5
Oranges $20
Bananas $15
Apples $10
Pears $50
Apples $30

From the chart above, I can see that the LEAST amount spent on Apples was
$5. I would like to create a formula that would lookup Apples in column A and
then give me the lease amount I've spent on apples in the corresponding
amount from column B.

Any help is much appreciated. Thank you!