# How to Find Minimum Value with VLOOKUP in Excel (6 Ways)

We will use the following data table to explain the methods to find minimum value with VLOOKUP in Excel.

### Method 1: Minimum Value with VLOOKUP Function

#### 1.1. Find Minimum Value

Steps:

âž¤ Select the output Cell C12

âž¤ Enter the following formula

`=VLOOKUP(MIN(\$C\$5:\$C\$10),\$C\$5:\$D\$10,1,FALSE)`

Â ðŸ’¡Â  Formula Breakdown

MIN(\$C\$5:\$C\$10) will return the minimum value in the range \$C\$5:\$C\$10

\$C\$5:\$D\$10 is the table array, 1 is the column index number which is the Grade column, and FALSE is for Exact Match

âž¤ Press ENTER

You will find the Minimum Mark which is 65.

Read More: How to Find Minimum Value in Excel

#### 1.2. Return Adjacent Cell of Minimum Value

Steps:

âž¤ Select the output cell C12.

âž¤ Enter the formula.

`=VLOOKUP(MIN(\$C\$5:\$C\$10),\$C\$5:\$D\$10,2,FALSE)`

âž¤ Press ENTER.

You will find the Minimum Grade which is Grade D.

#### 1.3. Return Multiple Values with VLOOKUP

Steps:

âž¤ Select the output cell B13.

âž¤ Enter the following formula

`=VLOOKUP(MIN(C5:C10),\$C\$5:\$E\$10,{2,3},FALSE)`

Â ðŸ’¡Â  Formula Breakdown

MIN(C5:C10) will return the minimum value in the range of C5:C10.

\$C\$5:\$E\$10 is the table array, {2,3} is the array of the column index number and FALSE is for Exact Match

âž¤ Press ENTER.

You will find the Minimum Grade which is D, and the corresponding subject Physics.

### Method 2: Using INDEX-MATCH Function

Steps:

âž¤ Select the Cell C12

âž¤ Enter the following formula

`=INDEX(B5:B10,MATCH(MIN(C5:C10),C5:C10,0))`

Â ðŸ’¡ Â Formula Breakdown

MIN(C5:C10) will return the minimum value in the range of C5:C10

C5:D10 is the lookup array, and 0 is for Exact Match.

B5:B10 is the range of studentâ€™s name that you want as a result.

âž¤Press ENTER

You will find the name of the student with the lowest mark.

Read More: How to Find Lowest 3 Values in Excel

Method 3: Find nth Minimum Value with VLOOKUP

Steps:

âž¤ Select the output cell C12.

âž¤ Apply the following formula to find the 2nd minimum value.

`=VLOOKUP(SMALL(C5:C10,2),C5:D10,2,FALSE)`

ðŸ’¡Â Formula Breakedown

SMALL(C5:C10,2) will return the 2nd minimum value in the range C5:C10, where 2 is the kth value.

C5:D10 is the table array, 2 is the column index number which is the Grade column,Â and FALSE is for Exact Match.

You will find the 2nd Minimum Grade which is Grade C.

âž¤ For getting the 4th minimum value, change the second argument of the SMALL function.

`=VLOOKUP(SMALL(C5:C10,2),C5:D10,4,FALSE)`

Read More: How to Find Lowest Value with Criteria in Excel

### Method 4: Using MINA with VLOOKUP Function

âž¤ Select the output cell C12.

âž¤ Enter the following formula.

`=VLOOKUP(MINA(C5:C10),\$C\$5:\$D\$10,2,0)`

Â ðŸ’¡ Â Formula Breakdown

MINA(C5:C10) will return the minimum value in the range of C5:C10.

\$C\$5:\$D\$10 is the table array, 2 is the column index number which is the Grade column,Â and FALSE is for Exact Match.

You will find the Minimum Grade which is Grade D.

### Method 5: Using MIN and IF function

âž¤ Select the output cell C12.

âž¤ Enter the following formula.

`=MIN(IF(\$B\$5:\$B\$10=B5:B10,\$C\$5:\$C\$10))`

Â ðŸ’¡ Â Formula Breakdown

B5:B10 is the range of Students and \$C\$5:\$C\$10 is the range of Marks.

\$B\$5:\$B\$10=B5:B10 is the logical test in the IF function and \$C\$5:\$C\$10 is the value when the logical test is TRUE.

You will find the Minimum Marks which is 65.

### Method 6: Use VLOOKUP to Find Minimum Value in a Row

In the following table, there are 3 rows for marks of 3 subjects. To know the minimum mark for any of the subjects you have to find the minimum value row-wise. You can use the MIN function and the VLOOKUP function for this purpose.

âž¤ Select the output cell C11.

âž¤ Apply the following formula.

`=MIN(VLOOKUP(B11,\$B\$6:\$F\$8,{2,3,4,5},FALSE))`

B11 is the lookup value, \$B\$6:\$F\$8 is the table array, {2,3,4,5} is the array of the column index number.

You will find the minimum mark which is 65 for Chemistry.

Read More: How to Find Minimum Value That Is Greater Than 0 in Excel

## How to Find Minimum Value with Multiple Criteria in Excel

Let’s say you want to find the minimum sales for the North region, specifically for orders with a quantity greater than 60 in the sample dataset below. In this case, you would use the MIN function and the IF function.

Steps:

âž¤Select the output Cell G6

âž¤Enter the following formula

`=MIN(IF(C5:C12=F6,IF(D5:D12>60,E5:E12)))`

Â ðŸ’¡Â  Formula Breakdown

C5:C12 is the range of Region, D5:D12 is the range of Quantity and E5:E12 is the range of Sales.

C5:C12=F6 is the first logical test in the IF function and IF(D5:D12>60, E5:E12) is the value when the logical test is TRUE.

âž¤Press ENTER and you will find the Minimum Sales which is \$2,785.00.

## Related Articles

<< Go Back toÂ Excel MIN Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF