Just some thoughts. "Date/s" require extra care in matching as any formatting
applied may disguise the underlying value. For example: "May 2008" which
shows in a cell may actually house the date: 1-May-2008 with the cell
formatted to display as: mmm yyyy. Or it may actually house the text: May
2008 (entered with a preceding apostrophe). Both data won't match with each
other.

if the value for May 2008 is 87.5% on the table in worksheet 1,
Assume the "May 2008" above is in A2, in Sheet1

when I enter the May 2008 in a table on worksheet 2
Assume the "May 2008" above is in C2, in Sheet2

Do this test in any empty cell in Sheet2: =C2=Sheet1!A2
What do you get? If both match, it should read TRUE

Assuming the lookup col contains text labels: May 2008
while the lookup values are actually real dates (formatted),
you can make the lookup values consistent for matching with the text labels
via using TEXT, something like this:
=VLOOKUP(TEXT(A1,"mmm yyyy"),Sheet1!A:B,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---