Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return the value of a column heading
Here's my data...
A B C D E F G H 1 Name First Last Jan Feb Mar Apr May 2 John ____ ____ 5 10 5 3 Jim ____ ____ 3 6 5 How do I get B2 to return "Feb" and C2 to return "Apr"; B3 to return "Jan" and C3 to return "Mar"? Hopefully the spacing won't lose anything when posted. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return the value of a column heading
Try these:
B2: =IF(COUNT(D2:H2),INDEX(D$1:H$1,MATCH(TRUE,INDEX(D2 :H2<"",0),0)),"") C2: =IF(COUNT(D2:H2),LOOKUP(1E100,D2:H2,D$1:H$1),"") Select both B2 and C2 then copy down as needed. -- Biff Microsoft Excel MVP "Eric" wrote in message ... Here's my data... A B C D E F G H 1 Name First Last Jan Feb Mar Apr May 2 John ____ ____ 5 10 5 3 Jim ____ ____ 3 6 5 How do I get B2 to return "Feb" and C2 to return "Apr"; B3 to return "Jan" and C3 to return "Mar"? Hopefully the spacing won't lose anything when posted. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return column heading | Excel Worksheet Functions | |||
*HELP* Need a cell to return a column heading | Excel Discussion (Misc queries) | |||
Return Column Heading after lookup | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Formula to Return Column Heading | Excel Discussion (Misc queries) |