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

Hi corinereyes,

Your formula gives me #N/A !
Do you know why. To be more accurate, my data are in A8:A43 for the dates and I8:I43 for the percentages.

#N/A indicates that VLOOKUP has not found a match to your date.

You will have to alter Corines formula to fit your data ranges as follows:

Please Login or Register  to view this content.

Note that the match must be EXACT
thus if the dates are EXCEL dates in the table but TEXT in the lookup,
or visa versa, then it will not work.

Mark

Note that EXCEL will convert Feb 04 into a numberic value representing the number of days between
the First of January 1900 until the First of Febuary 2004.

so if you look for 2/2/04 it won't be found!

it is possible to ask VLOOKUP to find the closest match, if the dates in your table are in ascending order (most recent date at the bottom).

Just change the False in the formula to True.

Mark