Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

1. I agreed to these rules
Join Date
6th July 2007
Posts
3

## Lookup Minimum Values

I have 3 columns of data consisting of the name of a retailer, their respective country (US, Canada and Mexico) and the average price for each retailer. Theres a bunch of retailers for each country.

How can I design an array/table which will show the cheapest retailer from each country?

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Vlookup And Min Values

Why did you post in the SQL/Excel help forum?

3. ## Re: Vlookup And Min Values

Nest MIN in the VLOOKUP lookup_value argument.

4. I agreed to these rules
Join Date
6th July 2007
Posts
3

## Re: Vlookup And Min Values

Originally Posted by Dave Hawley
Obviously it was a mistake.

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Vlookup And Min Values

More like you didn't bother reading the message about are you sure this is the right forum.

6. I agreed to these rules
Join Date
6th July 2007
Posts
3

## Re: Vlookup And Min Values

Originally Posted by Dave Hawley
More like you didn't bother reading the message about are you sure this is the right forum.
I was sure at the time; it said Excel in the title.

Excel Video Tutorials / Excel Dashboards Reports

7. ## Re: Vlookup And Min Values

No, it said SQL/Excel as Reafidy already pointed out.

When you ignored the Welcome thread that you were instructed to read, you also ignored this;

If you understand and agree to this, feel free to use the New Thread button in the most applicable Question Forum

8. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,678

## Re: Vlookup And Min Values

Hi,

Try,

=INDEX(A1:A20,SMALL(IF(C2:C20=MIN(IF(B2:B20="us",C2:C20)),IF(B2:B20="us",ROW(C2:C20))),1))

where Col A houses retailer name, COl B houses country and Col C houses price

To Enter the array formula hold down Ctrl and Shift while pushing Enter.

HTH

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno