Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Lookup Minimum Values

  1. #1
    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. #2
    Join Date
    8th December 2006
    Location
    New Zealand
    Posts
    4,284

    Re: Vlookup And Min Values

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

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    Re: Vlookup And Min Values

    Nest MIN in the VLOOKUP lookup_value argument.

    Answer Reafidy's question 1st please.

  4. #4
    Join Date
    6th July 2007
    Posts
    3

    Re: Vlookup And Min Values

    Quote Originally Posted by Dave Hawley
    Answer Reafidy's question 1st please.
    Obviously it was a mistake.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    Re: Vlookup And Min Values

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

  6. #6
    Join Date
    6th July 2007
    Posts
    3

    Re: Vlookup And Min Values

    Quote 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. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    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. #8
    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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Find 2 Corresponding Values & Multiple The Minimum
    By kathyb0527 in forum Excel General
    Replies: 6
    Last Post: January 11th, 2008, 09:06
  2. Copy Values Between Minimum & Maximum
    By Grumble in forum Excel General
    Replies: 5
    Last Post: July 6th, 2007, 00:52
  3. Finding Minimum And Maximum Values From A Database
    By aurobless in forum Excel General
    Replies: 2
    Last Post: April 17th, 2007, 22:33
  4. Exclude Minimum Two Values In Average
    By aubie8 in forum Excel General
    Replies: 3
    Last Post: December 8th, 2006, 06:04
  5. Lookup Maximum & Minimum. Return Corresponding Row
    By rex.morgan in forum Excel General
    Replies: 4
    Last Post: November 3rd, 2006, 21:44

Bookmarks

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