Search code examples
excelvlookupmin

find the minimum value in Excel

Lets say i have two columns as follows :

Column A        Column B
apples           1.2
apples           1
bananas          2
oranges          2.3
oranges          2.1
oranges          2.4

In another sheet, I've got apples/bananas/oranges in a column and I want to look up only the minimum value for each. I tried vlookup but it gives me the absolute minimum of all only once. I know I'm missing something here any help?

Solution

  • Use MINIFS() Function, --> Excel Users --> MS365/Excel 2021/2019

    enter image description here

    • Formula used in cell F2

    =MINIFS($B$2:$B$7,$A$2:$A$7,E2)

    If not using any one of the above version of Excel then use the below

    • Formula used in cell G2

    =MIN(IF(E2=$A$2:$A$7,$B$2:$B$7,""))

    The above formula needs to press CTRL + SHIFT + ENTER based on Excel version.