To put into context, I am trying to lookup a purchase order number based on a number of criteria (Contractor id number, unit of measure etc). PO numbers are held from a start date to an end date and then a new PO number will be raised once the previous has expired. This means that there may be multiple results for the search criteria.

The crucial criteria that would result in the correct PO number being given is a week ending date (e.g 28/04/13). The sheet that i am looking up against contains all the required criteria but has a start date column and an end date column instead of a week ending date

I can concatinate all but the week ending date on both sheets and vlookup, but there will be multiple results and it just retruns the 1st result found. I need it to return the result based on the line that meets my date criteria (e.g. week ending date is less than end date column and greater than start date column)

Hope that makes sense?

Any help would be greatly appreciated!!
Thanks

Daaanj