Vlookup Function

Discussion in 'Excel Programming' started by keycomboy@gmail.com, May 1, 2014.

  1. Guest

    Hi,
    I am trying to use the vlookup function to do the following:

    1. find the lookup value in column 1
    2. find the highest value in the same row as the lookup value
    3. return the value form the first row in the same column as the highest value

    Hope this makes sense

    Thanks for any help
     
    , May 1, 2014
    #1
    1. Advertisements

  2. Don Guillett Guest

    On Thursday, May 1, 2014 9:04:01 AM UTC-5, wrote:
    > Hi,
    >
    > I am trying to use the vlookup function to do the following:
    >
    >
    >
    > 1. find the lookup value in column 1
    >
    > 2. find the highest value in the same row as the lookup value
    >
    > 3. return the value form the first row in the same column as the highest value
    >
    >
    >
    > Hope this makes sense
    >
    >
    >
    > Thanks for any help


    Why? Homework?
     
    Don Guillett, May 4, 2014
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Walt F.

    enormous file size - VLOOKUP function?

    Walt F., Jul 11, 2003, in forum: Excel Programming
    Replies:
    2
    Views:
    119
    Walt F
    Jul 14, 2003
  2. Juanfer

    Using the Vlookup Function in VB Code

    Juanfer, Sep 4, 2003, in forum: Excel Programming
    Replies:
    1
    Views:
    74
    Doug Glancy
    Sep 4, 2003
  3. dreastman
    Replies:
    3
    Views:
    163
    dreastman
    Jun 9, 2005
  4. erikhs
    Replies:
    1
    Views:
    168
    Peter T
    Aug 6, 2006
  5. Replies:
    8
    Views:
    210
  6. Roger on Excel
    Replies:
    1
    Views:
    210
  7. Fred
    Replies:
    2
    Views:
    229
  8. Roger on Excel

    vlookup from two sources - syntax of vlookup statement

    Roger on Excel, Dec 14, 2009, in forum: Excel Programming
    Replies:
    2
    Views:
    194
    Bernard Liengme
    Dec 14, 2009
Loading...