Look up Help

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

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
 
I'm not sure what you want, but I'll give it a shot...

If you have =IF(ISNUMBER(-LEFT(C2,2))=TRUE,LEFT(C2,2)
,MID(C2,4,2)) in cell G2 they would combine as follows

=LOOKUP(IF(ISNUMBER(-LEFT(C2,2))=TRUE,LEFT(C2,2),
MID(C2,4,2)),Lookup!$A$2:$A$15,Lookup!$B$2:$B$15)

If your =LOOKUP(G2,Lookup!$A$2:$A$15,Lookup!$B$2:$B$15)
is returning a value to C2 then you would have

=IF(ISNUMBER(-LEFT(LOOKUP(G2,Lookup!$A$2:$A$15,
Lookup!$B$2:$B$15),2))=TRUE,LEFT(LOOKUP(G2,
Lookup!$A$2:$A$15,Lookup!$B$2:$B$15),2),MID(LOOKUP
(G2,Lookup!$A$2:$A$15,Lookup!$B$2:$B$15),4,2))

Dan E
 
Back
Top