Skip to content

Lookup the Smallest or Largest Value

Let’s say you have some data like this in Google Sheets.

Your goal is to return the sales agent with the largest total sales and the sales agent with the smallest total sales.

Here is how to do it!

Get the Smallest Value

Select the cell where you want to list the sales agent with the smallest total sales number and enter the following formula.

=XLOOKUP(MIN(TotalSales), TotalSales, AgentList)

As a result, you get back the sales agent with the smallest total sales.

Formula Explanation

Let’s look at how this formula works. We will work from the inside out and begin with the MIN function.

The MIN function finds and returns the smallest total sales number.

=XLOOKUP(117, TotalSales, AgentList)

The XLOOKUP function searches for this value in the total sales column and returns the corresponding sales agent.

As a result, you get back the sales agent with the smallest total sales number.

Get the Largest Value

Select the cell where you want to list the sales agent with the largest total sales number and enter the following formula.

=XLOOKUP(MAX(TotalSales), TotalSales, AgentList)

As a result, you get back the sales agent with the largest total sales.

Formula Explanation

Let’s look at how this formula works. We will work from the inside out and begin with the MAX function.

The MAX function finds and returns the largest total sales number.

=XLOOKUP(863, TotalSales, AgentList)

The XLOOKUP function searches for this value in the total sales column and returns the corresponding sales agent.

As a result, you get back the sales agent with the largest total sales number.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top