I have a spreadsheet that looks like this:

1/1/09 <blank
1/2/09 DISC
1/3/09 <blank
1/4/09 <blank
1/5/09 <blank
1/6/09 DISC

I need to search the table and be able to report out all the dates where the
"DISC" value is in column B. The location where I want to report these will
be a separate workbook in the spreadsheet and I want them each reported as a
separate cell in a single row. Is there a way to use Vlookup to search the
2nd column and report the value from the first column....or is there some
other method of doing this ?

Thanks !