If I understand correctly, you have something like this:

Column A Column B
2/1/2007 Text
2/2/2007 Text
2/3/2007 Text

And in another worksheet (same workbook maybe?)

Column A
2/1/2007
3/1/2007

and you want to locate column B from worksheet 1 above and enter it into,
say, column B of worksheet 2.

If so,

in column B of sheet 2
=vlookup(A1,Sheet1!A1:B200,2,FALSE)

will return the matching text from the date on sheet1. If the date doesn't
exist in column 1, you'll get an #N/A in the field. To avoid this:

=if(iserror(vlookup(A1,Sheet1!A1:B200,2,FALSE),"", vlookup(A1,Sheet1!A1:B200,2,FALSE))

will leave a blank instead.

"newyorkjoy" wrote:

I am using EXCEL 2003. I have a worksheet with a column of all dates from
1/1/1900 through the present. I am getting new data in two columns. One of
dates, and one of information to match the dates. I need to add a column to
my original worksheet showing the information I need for specific dates. How
can I get excel to automatically find the matching date, and put only the
information in the second column in a new column next to the corresponding
date?
--
newyorkjoy
thanks for the help!