II have a list that contains col. A with dates in it. Cols. B, C, D, E,
and so on contains either a number or "Free" or "Vac". I need to
extract the dates that have Vac. beside them and have them listed on
another sheet, per the following example. Is index/match the way to go
about this? Thanks for any help you can give.

Date Tom Dick Harry
1/2 8 8
Vac.
1/3 8 Vac. 8
1/4 Vac. 8 Free
1/5 Vac. Vac. 8




Summary on next sheet:

Tom Dick Harry
1/4 1/3 1/2
1/5 1/5