Help Adding Another layer to if/lookup statement

[jealkon]

Using this statement to return rate values and need to another another layer. What I’m looking to do is take this statement another level and if the contractor is working on a non-billed project, return the base rate from the contractor worksheet in column “B” and not the margined rate found in column “D”

=IF(ISERROR(VLOOKUP($C2,Contractors!$A:$D,4,0)),IF(ISERROR(VLOOKUP($A2,'Billable Projects'!$A:$B,2,0)),VLOOKUP(Detail!$G2,Names!$B:$E,4,0),VLOOKUP($A2,'Billable Projects'!$A:$B,2,0)),VLOOKUP($C2,Contractors!$A:$D,4,0))

So, using the attached file, the rate for Williams, Roselyn would be $29.77 and not $35.03.

Thanks for your help.

[bebo021999]

Doing slightly admenment in the column number of the last VLOOKUP:
=IF(ISERROR(VLOOKUP($C2,Contractors!$A:$D,4,0)),IF(ISERROR(VLOOKUP($A2,'Billable Projects'!$A:$B,2,0)),VLOOKUP(Detail!$G2,Names!$B:$E,4,0),VLOOKUP($A2,'Billable Projects'!$A:$B,2,0)),VLOOKUP($C2,Contractors!$A:$D,IF(F2="NON_BILL",2,4),0))

[jealkon]

Thanks so much for the help. Worked perfectly