Welcome Guest
You last visited June 26, 2017, 6:20 pm
All times shown are
Eastern Time (GMT-5:00)

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

 Page 1 of 1
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

LG

New Jersey
United States
Member #17843
June 28, 2005
60973 Posts
Online
 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

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!

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

 Page 1 of 1