combine two formulaes

[projectile]

can someone advise how I can amalgamate the two formulas into one?

=IF(ISNUMBER(MATCH(sheet1!R6,sheet2!$L:$L,0)),INDEX(sheet2!$J:$J,MATCH(sheet1!R6,sheet2!$L:$L,0)),"NOT DONE")

=IF(E6="SHIPPER",INDEX(Client!$C:$C,MATCH(sheet1!C6,sheet3!$A$2:$A$10000)))

 

[Jonmo1]

Here's a guess.

=IF(ISNUMBER(MATCH(sheet1!R6,sheet2!$L:$L,0)),INDEX(sheet2!$J:$J,MATCH(sheet1!R6,sheet2!$L:$L,0)),IF(E6="SHIPPER",INDEX(Client!$C:$C,MATCH(sheet1!C6,sheet3!$A$2:$A$10000)),"Not Done"))

 

[projectile]

Thanks that works!!