Forumala combo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top