+ Reply to Thread
Results 1 to 10 of 10

Lookup min & column heading

  1. #1
    Bob Phillips
    Guest

    Re: Lookup min & column heading

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Greg" <[email protected]> wrote in message
    news:[email protected]...
    > I'm trying do a lookup to find 'min' then lookup to see what month.

    here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    the
    > month.
    > Any help is appreciated. Thanks, Greg
    >
    >




  2. #2
    Domenic
    Guest

    Re: Lookup min & column heading

    Try...

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    Hope this helps!

    In article <[email protected]>,
    "Greg" <[email protected]> wrote:

    > I'm trying do a lookup to find 'min' then lookup to see what month. here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get the
    > month.
    > Any help is appreciated. Thanks, Greg


  3. #3
    Greg
    Guest

    Re: Lookup min & column heading

    Worked perfectly Bob. Thanks, Greg

    "Bob Phillips" wrote:

    > =INDEX(A1:E1,MATCH(F2,A2:E2,0))
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Greg" <[email protected]> wrote in message
    > news:[email protected]...
    > > I'm trying do a lookup to find 'min' then lookup to see what month.

    > here's
    > > my example:
    > >
    > > A B C D E F G
    > > 1 jan feb mar apr may min month
    > > 2 8 7 2 6 8 2 mar
    > >
    > > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    > the
    > > month.
    > > Any help is appreciated. Thanks, Greg
    > >
    > >

    >
    >
    >


  4. #4
    Bob Phillips
    Guest

    Re: Lookup min & column heading

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Greg" <[email protected]> wrote in message
    news:[email protected]...
    > I'm trying do a lookup to find 'min' then lookup to see what month.

    here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    the
    > month.
    > Any help is appreciated. Thanks, Greg
    >
    >




  5. #5
    Domenic
    Guest

    Re: Lookup min & column heading

    Try...

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    Hope this helps!

    In article <[email protected]>,
    "Greg" <[email protected]> wrote:

    > I'm trying do a lookup to find 'min' then lookup to see what month. here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get the
    > month.
    > Any help is appreciated. Thanks, Greg


  6. #6
    Greg
    Guest

    Re: Lookup min & column heading

    Worked perfectly Bob. Thanks, Greg

    "Bob Phillips" wrote:

    > =INDEX(A1:E1,MATCH(F2,A2:E2,0))
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Greg" <[email protected]> wrote in message
    > news:[email protected]...
    > > I'm trying do a lookup to find 'min' then lookup to see what month.

    > here's
    > > my example:
    > >
    > > A B C D E F G
    > > 1 jan feb mar apr may min month
    > > 2 8 7 2 6 8 2 mar
    > >
    > > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    > the
    > > month.
    > > Any help is appreciated. Thanks, Greg
    > >
    > >

    >
    >
    >


  7. #7
    Greg
    Guest

    Lookup min & column heading

    I'm trying do a lookup to find 'min' then lookup to see what month. here's
    my example:

    A B C D E F G
    1 jan feb mar apr may min month
    2 8 7 2 6 8 2 mar

    My 'min' formula answer is in F2, but I'd like a formulat for G2 to get the
    month.
    Any help is appreciated. Thanks, Greg



  8. #8
    Bob Phillips
    Guest

    Re: Lookup min & column heading

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Greg" <[email protected]> wrote in message
    news:[email protected]...
    > I'm trying do a lookup to find 'min' then lookup to see what month.

    here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    the
    > month.
    > Any help is appreciated. Thanks, Greg
    >
    >




  9. #9
    Domenic
    Guest

    Re: Lookup min & column heading

    Try...

    =INDEX(A1:E1,MATCH(F2,A2:E2,0))

    Hope this helps!

    In article <[email protected]>,
    "Greg" <[email protected]> wrote:

    > I'm trying do a lookup to find 'min' then lookup to see what month. here's
    > my example:
    >
    > A B C D E F G
    > 1 jan feb mar apr may min month
    > 2 8 7 2 6 8 2 mar
    >
    > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get the
    > month.
    > Any help is appreciated. Thanks, Greg


  10. #10
    Greg
    Guest

    Re: Lookup min & column heading

    Worked perfectly Bob. Thanks, Greg

    "Bob Phillips" wrote:

    > =INDEX(A1:E1,MATCH(F2,A2:E2,0))
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Greg" <[email protected]> wrote in message
    > news:[email protected]...
    > > I'm trying do a lookup to find 'min' then lookup to see what month.

    > here's
    > > my example:
    > >
    > > A B C D E F G
    > > 1 jan feb mar apr may min month
    > > 2 8 7 2 6 8 2 mar
    > >
    > > My 'min' formula answer is in F2, but I'd like a formulat for G2 to get

    > the
    > > month.
    > > Any help is appreciated. Thanks, Greg
    > >
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1