Results 1 to 4 of 4

Vlookup Lowest value...?

This is a discussion on Vlookup Lowest value...? within the Excel Questions forums, part of the Question Forums category; Hi Guys, hopefully an easy question for you. I have a list of town names (col A) and a list ...

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    16

    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

  2. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    11,638

    Default Re: Vlookup Lowest value...?

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

    Please surround your pasted VBA code with CODE tags e.g.;
    [CODE] your VBA code here [/CODE]
    The pound # icon in the forum editor will apply the CODE tags around your selected text.

  3. #3
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    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]

  4. #4
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    62,842

    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: Forum Rules).
    HTH, Peter
    Please test any code on a copy of your workbook.

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