Given the following, how can I perform the lookup?

I have two tables. The first table has employee names in Column A, and
Columns B through K contain requested days off for each employee.

Name 1 2 3 4
John Smith 09-15-06 09-16-06 09-17-06 etc.
Judy Jones 10-11-06 10-12-06 11-01-06 etc.


The second table is a calendar that lists employee names in Column A and the
dates of the month in Columns B through AF. In the calendar table, I want to
be able to type in the employee name, and if there is a match between a
calendar date and a time off request for an employee, I want to display a €œV€�
in the cell. The formula needs to reference the cell in which the employee
name is entered.

09-14-06 09-15-06 09-16-06 09-17-06 09-18-06
John Smith V V V

The employee name in the second table is variable, depending on the result
of other formulas, or it could be typed into the cell.

How can I do this?


Thanks,

--- Don Q.