[QUOTE=KevinRamsay;3446055I thought with would work - what it doesn't[/QUOTE]

Note that I've also used the fourth parameter in the VLOOKUP function, set to zero (or FALSE), which means to look for an exact match.

Also, your sheet name seems to have changed to Active Projects, rather than Active, and you are now using B29 rather than B28 as your lookup value.

Pete