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

Ask a Question

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.