VLOOKUP help required

I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do.   On the main worksheet I have populated the Project Category using VLOOKUP based on the ...