Combining two formulas

From PM:

I tried to add another column but it's not working can you help me out on it it's returning a 0.
here is the formula

=IF(P9="","",IF(ISNA(VLOOKUP(P9,DATA!$A$14:$C$23,3,0)),IF(ISNA(VLOOKUP(P9,DATA!$D$6:$E$23,2,0)),IF(ISNA(VLOOKUP(P9,DATA!$F$6:$G$23,2,0)),"",VLOOKUP(P9,DATA!$F$6:$G$23,2,0)),VLOOKUP(P9,DATA!$D$6:$E$23,2,0)),VLOOKUP(P9,DATA!$A$14:$C$23,3,0)))

thx,
mrggutz

If you are referring still to the same workbook as you had previously attached... I think your merged columns are messing you up. It is advisable to no use merged columns as they lead to confusion and messy formulas....

Bust, as you have the sheet now, try instead

=IF(P9="","",IF(ISNA(VLOOKUP(P9,DATA!$A$14:$B$23,2,0)),IF(ISNA(VLOOKUP(P9,DATA!$C$6:$E$23,3,0)),IF(ISNA(VLOOKUP(P9,DATA!$F$6:$G$23,2,0)),"",VLOOKUP(P9,DATA!$F$6:$G$23,2,0)),VLOOKUP(P9,DATA!$C$6:$E$23,3,0)),VLOOKUP(P9,DATA!$A$14:$B$23,2,0)))