Maybe..
=IF(ISERROR(FIND("Personal",PROPER(H2))),IF(ISERROR(FIND("PNS",H2)),IF(LEFT(G2,1)="7","Mobile",""),"Personal "),"Personal")
or even better
=IF(ISERROR(FIND("PERSONAL",UPPER(H2))),IF(ISERROR(FIND("PNS",UPPER(H2))),IF(LEFT(G2,1)="7","Mobile",""),"Personal "),"Personal")
Bookmarks