Vlookup Lowest value...?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Vlookup Lowest value...?

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup Lowest value...?

     
    Hi Guys, hopefully an easy question for you.

    I have a list of town names (col A) and a list of figures (col B). they are random but what I would like to do is take out the lowest figure from column B against the town name.

    For example
    Col A Col B
    york 10
    york 9
    york 5
    london 20
    london 12
    london 54
    london 32
    reading 10
    reading 41
    newbury 22

    I have the town name, once, in another sheet and was thinking of doing a vlookup but to only bring the lowest number out. So for London, it would bring back '12'

    Hope thats enough info.

    Thanks

    Stew
    0 0
     

  2. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,523
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Vlookup Lowest value...?

    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    How to post your vba code
    [CODE]your VBA code here[/CODE]
    The # button in the forum's editor will apply CODE tags around your selected text.
    0 0
     

  3. #3
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,292
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup Lowest value...?

    Try something like: =MIN(IF(Sheet1!A1:A10=A1,Sheet1!B1:B10))

    Confirmed with Ctrl+Shift+Enter as it's an array formula.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]
    0 0
     

  4. #4
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Vlookup Lowest value...?

      
    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).
    HTH, Peter
    Please test any code on a copy of your workbook.
    0 0
     

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com