I have a worksheet that has names & information in columns A-D. In the
adjacent columns it has blocks for each day of the month. Next to the names
each cell has a value of either "1", "L", or "T". I am trying to set up a
lookup formula to return all of the names in column A that have a cell value
of "L" depending on the corresponding day. Say:

A B C D E F G H I J K
Feb 2004 1 2 3 4 5 6 7
ADAMS D 3 Off 1 1 1 1 1 L L
JONHSON J 5 Sup 1 1 L L L L 1
WILLIAMS C 7 Road 1 L L L 1 1 1



I want it to tell me:

1 Feb:
2 Feb: Willaims
3 Feb: Johnson, Willaims
4 Feb: Johnson, Willaims
5 Feb: Johnson
6 Feb: Adams, Johnson
7 Feb: Adams

I am currently using this formula:

=IF('[workbook.xls]Jan 03:Dec 05'!2:2=TODAY(),LOOKUP("L",'[workbook.xls]Jan
03:Dec 05'!$2:$2,'[workbook.xls]Jan 03:Dec 05'!$A:$AK), FALSE())

Column 2 of "workbook.xls" is a hidden column with the proper date format
(2/1/05). Any suggestions?