Welcome Guest
Log In | Register )
You last visited December 10, 2016, 11:28 am
All times shown are
Eastern Time (GMT-5:00)

excel help please

Topic closed. 2 replies. Last post 6 years ago by lottogloria.

Page 1 of 1
PrintE-mailLink
lottogloria's avatar - DiscoBallGlowing
cleveland
United States
Member #35045
March 11, 2006
40 Posts
Offline
Posted: August 22, 2010, 6:13 pm - IP Logged

LOOKING FOR A FORMULA TO TELL ME WHICH COLUMN IT CAME FROM

EXAMPLE
C           D       E              F          G         UP  TO AG
DRAW          UNIT1      UNIT2    UNIT 3

I WANT THE FORMULA TO GIVE ME THE UNIT NUMBER THE DRAW WAS FOUND IN

THANKS IN ADVANCE
                                          LG

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49823 Posts
    Offline
    Posted: August 23, 2010, 10:18 am - IP Logged

    LOOKING FOR A FORMULA TO TELL ME WHICH COLUMN IT CAME FROM

    EXAMPLE
    C           D       E              F          G         UP  TO AG
    DRAW          UNIT1      UNIT2    UNIT 3

    I WANT THE FORMULA TO GIVE ME THE UNIT NUMBER THE DRAW WAS FOUND IN

    THANKS IN ADVANCE
                                              LG

    =VLOOKUP($C$1,$C$1:$AG$1,MATCH($C2,$D2:$AG2,0)+1)

    A mind once stretched by a new idea never returns to its original dimensions!

      lottogloria's avatar - DiscoBallGlowing
      cleveland
      United States
      Member #35045
      March 11, 2006
      40 Posts
      Offline
      Posted: August 24, 2010, 9:27 pm - IP Logged

      =VLOOKUP($C$1,$C$1:$AG$1,MATCH($C2,$D2:$AG2,0)+1)

      THANK YOU FOR RESPONDING BUT IT NOT WHAT I WAS LOOKING FOR.LET SEE IF I CAN EXPLAIN BETTER. I NEW AT THIS EXCEL STUFF

      I HAVE 25 ROWS OF NUMBER AND 40 COLUMN I WANT TO FIND WHAT COLUMN THE DRAW SHOWED UP IN

      THANKS ANY HELP
                                                           LG