Nested VLookup, Match Formula Help Needed

Trying to update a formula provided once before to now include additional criteria and failing.
On Detail sheet in column “K”, looking to return values depending on specific criteria.
On the detail worksheet, lookup name in column on the Contractor worksheet, return value from column “D”, if not found, return to detail worksheet and lookup project name in column “A” on the billable project worksheet & return value form column “B”, if neither of these, return to detail worksheet and lookup value in column “G” (Team) on the Names worksheet and return value in column “E”.
Does this make sense?