find and copy matched cell on other worksheet

Hi,

Here is my problem:

On one of my worksheet I have dates from Jan 04, Feb 04, ... to Dec 06 (in column A) and each date matches with a percentage (in column B).

I would like to report on another worksheet the corresponding percentage when I enter a date, e.g. if a enter Feb 04 in cell C9 I want the corresponding percentage to show up in cell E9.

How is this possible?
Thanks

On the "data" sheet where your dates are. Are they entered as text (such as "Jan '04) or entered as a date (01/01/2004 but displayed as Jan 04)?

It is entered as a date 1/1/2004 and displayed as Jan 04

Try this,

=VLOOKUP(D1,A1:B1000,2)

Where cell D1 is the date in question.

Matt

Thanks this is working great