Another formula question
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!
|