John,
Thanks so much for your help. This has worked perfectly.

Thanks again.
Rob Michael


John Keith wrote:
You will need to use the range lookup feature of the vlookup function.
This requires that the table array is sorted. Be sure to use Project as the
primary sort key then Start Date as the secondary sort key.

Add a new col-C; so that the phase name will be pushed over to D
Then make col-C a simple concatenation of A&B; The result will convert the
date to it's universal date I.E the first one will look like "Project A39223"

This is the formaula that will return "Concept"
=VLOOKUP("Project A"&DATEVALUE("5/21/2007"),$C$2:$D$7,2,TRUE)

The date's data is probably what was causing your issues.

HTH

I am trying to build a table and formula to look up the phase of a project
based on the week that a piece of work was done. I need to do this for
[quoted text clipped - 27 lines]
Thanks,
Rob