I have been using this formula to solve my issuue:

=if(iserror(INDEX($B$1:$E$1,MATCH(B14,INDEX($B$2:$ E$11,MATCH(A14,$A$2:$A$11,0),0),0))),0,INDEX($B$1: $E$1,MATCH(B14,INDEX($B$2:$E$11,MATCH(A14,$A$2:$A$ 11,0),0),0)))

However, for a staff member not listed on a specific date, I would like to
search the next dates down until the staff member is found on a date, then
indicate the department thay worked.

Any help would be appreciated

A B C D E
SCHEDULE
1 DATE SALES MKTG GEN PROD
2 01/01/07 dh PL ST
3 01/02/07 MS HG DM RO
4 01/03/07 HG TW RO
5 01/04/07 MS HR HG RO
6 01/05/07 DM MG HG
7 01/06/07 SU MG
8 01/07/07 MG SU DH
9 01/08/07 DM DR RO
10 01/09/07 HG ES RO
11 01/10/07 ah TW GO
12
13 DATE STAFF DEPT Wk'd from Above
14 01/01/07 PL ??
15 01/06/07 MG ??
16 01/09/07 ES ??
17 01/06/07 SU ??
18 01/10/07 TW ??
19 01/03/07 RO ??
20 01/01/07 DH ??
21 01/06/07 SU ??
22 01/09/07 RO ??

I am trying to locate a matching value and return its columnheading.
Ex A5=vlaue to find in row5 to return column heading a4:z4

I do not fully understand your challenge, but a custom function could be
written to achieve your purpose.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"MFM" wrote:

I have been using this formula to solve my issuue:

=if(iserror(INDEX($B$1:$E$1,MATCH(B14,INDEX($B$2:$ E$11,MATCH(A14,$A$2:$A$11,0),0),0))),0,INDEX($B$1: $E$1,MATCH(B14,INDEX($B$2:$E$11,MATCH(A14,$A$2:$A$ 11,0),0),0)))

However, for a staff member not listed on a specific date, I would like to
search the next dates down until the staff member is found on a date, then
indicate the department thay worked.

Any help would be appreciated

A B C D E
SCHEDULE
1 DATE SALES MKTG GEN PROD
2 01/01/07 dh PL ST
3 01/02/07 MS HG DM RO
4 01/03/07 HG TW RO
5 01/04/07 MS HR HG RO
6 01/05/07 DM MG HG
7 01/06/07 SU MG
8 01/07/07 MG SU DH
9 01/08/07 DM DR RO
10 01/09/07 HG ES RO
11 01/10/07 ah TW GO
12
13 DATE STAFF DEPT Wk'd from Above
14 01/01/07 PL ??
15 01/06/07 MG ??
16 01/09/07 ES ??
17 01/06/07 SU ??
18 01/10/07 TW ??
19 01/03/07 RO ??
20 01/01/07 DH ??
21 01/06/07 SU ??
22 01/09/07 RO ??

I am trying to locate a matching value and return its columnheading.
Ex A5=vlaue to find in row5 to return column heading a4:z4