Nested Formula - Additional Help needed

Attached is my worksheet. I need help adding one additional lookup in Detail worksheet, column K (rate). If no rate is found using current criteria, lookup value in Detail worksheet column G (Team) and find it on the Project worksheet in column D (Team) and return the value in column E (rate)
Does this make sense?
Thanks for your help

You can change your formula in K2 to this:

=IF(ISNA(MATCH(C2,Contractors!A:A,0)),IF(ISNA(MATCH(A2,Projects!A:A,0)),IF(ISNA(MATCH(G2,Projects!D:D,0)),"",VLOOKUP(G2,Projects!D:E,2,0)),VLOOKUP(A2,Projects!A:B,2,0)),VLOOKUP(C2,Contractors!A:D,4,0))

and copy down, but it still doesn't give you a value in K2 or K6 as the teams CS_PMO and P&C NONBILL are not defined in your team table.

Hope this helps.

Pete

Thanks Pete - your help is very much appreciated

Once again, this site doens't fail me.