Vlookup Based on Date

[MjRmatt]

I am trying to put together a schedule in excel 2003 to return the applicable application date for a project dependent on the given month the schedule is being viewed.

I attempted long combination of IF & VLookup but excel 2003 doesnt allow me adequate space to complete the formula. Is there an alternative way?

Example attached

[Richard Buttrey]

Hi Matt,

First format B2 on Summary as a date rather than text.
Now ensure all your dates on row 2 of the Applications sheet are proper dates, e.g. 1/1/2011, 1/2/2011, etc. After March they were just text.

Now the formula in C4 of Summary is

Please Login or Register  to view this content.

Note that this is an array formula and must be entered with Ctrl-Shift-Enter. This is necessary since presumably any date could be entered in B2. If B2 always contains the first of any month then you could use the non array formula

Please Login or Register  to view this content.

HTH

[MjRmatt]

Many thanks, I cannot however get this to work. I have attached an updated example using your code, where am I going wrong?

[MjRmatt]

I also didnt point out that there will be multiple projects, hence my original use of vlookups. Can this formula be modified to match both the date entered with the relevant application date and return values based for multiple projects?

[mrc1386]

Heres an updated spreadsheet with logic to lookup the project name and the application date based on user input for month and project#.

Edited file 12:15est

[Richard Buttrey]

Hello Matt,

Yes you just need to include another MATCH() function to find the Project name. See attached.

Regards