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!
|