Nested "IF" Statement Syntax Help for MS Excel 2007

=IF(AND($C$4="YES, REPRESENTS ASSET OWNER",ISNA(VLOOKUP($M$5,'Inputs-LOAD_DATA_FOR_LARF'!$U$4:$V$40,2,FALSE))),"",VLOOKUP($M$5,'Inputs-LOAD_DATA_FOR_LARF'!$U$4:$V$40,2,FALSE)), IF(AND($C$4 ="YES, REPRESENTS LEAD OWNER",'Inputs-LOAD_DATA_FOR_LARF'!V4<>""),'Inputs-LOAD_DATA_FOR_LARF'!V4,"")
that ist red,blue,green part is the full IF statement and so the grey is not part of the IF as you already have the 3 factors

Test, "", vlookup
TEST ,TRUE , FALSE

Using "IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))" as my guide, I have tried to create a single, functional nested if statement to no avail. Here's my latest attempt that yielded #NA:

is the correct use of a nested IF

so the "" is common - it may be worth rearranging the tests so that a false is ""