Coba dengan : =IF(LEN(D3)>2,VLOOKUP(LEFT(D3,3),$B$9:$D$21,3,FALSE),"")&IF(LEN(D3)>5,", "&VLOOKUP(MID(D3,4,3),$B$9:$D$21,3,FALSE),"")&IF(LEN(D3)>8,", "&VLOOKUP(RIGHT(D3,3),$B$9:$D$21,3,FALSE),"")
Kid. 2011/11/2 <[email protected]> > Salam kenal, > > Para pakar xl, bantu untuk masalah saya ya... > Thanks. > > > > > > > > Best Regards, > > MGS. M. CANDRA SIGIT >
<<image/gif>>
<<image/gif>>
