VLOOKUP through code?

[Pozzi]

Hi,

I have two workbooks, the first is used to run a report, the other I want to use to archive the report just run.

The report allows the user to select a week commencing date, and they click run and the report is generated. Once generated I want to copy the report into the other workbook, this bit I think I should be fine with (he hopes).

In the archive workbook is a sheet named 'Calendar' and it contains a range showing the week commencing date and applicable week number for the year.

Example: -

Week Commencing	Week No
09/05/2005	1
16/05/2005	2
23/05/2005	3
30/05/2005	4
06/06/2005	5
13/06/2005	6

Through the code in the 'Report' workbook I want to take the previously supplied date e.g. 06/06/2005 and find out the week number (5).

Can I use VLOOKUP through the code?

If not how could I look up the week number?

I hope I've explained what I'm want to do clearly.

Regards