G
Guest
Is there a way that i can combine these two forumals
=IF(ISNUMBER(-LEFT(C2,2))=TRUE,LEFT(C2,2),MID(C2,4,2))
&
=LOOKUP(G2,Lookup!$A$2:$A$15,Lookup!$B$2:$B$15)
the cell that it looks in is c2
plus help
=IF(ISNUMBER(-LEFT(C2,2))=TRUE,LEFT(C2,2),MID(C2,4,2))
&
=LOOKUP(G2,Lookup!$A$2:$A$15,Lookup!$B$2:$B$15)
the cell that it looks in is c2
plus help