Ada. Formulanya pakai fungsi If: =IF(VLOOKUP($F$5,datalist,25,FALSE)=0,"",VLOOKUP($F$5,datalist,25,FALSE)).
Salam, Hendrik Karnadi ________________________________ From: deni ramdhani <[email protected]> To: "[email protected]" <[email protected]> Sent: Monday, 19 March 2012, 16:24 Subject: Re: [belajar-excel] isi sheet lain dalam 1 workbook otomatis terima kasih pak O' seno atas jawabannya d' problem solved, oh iya apa ada cara lain dengna tujuan yang sama ? >From: o' Seno <[email protected]> >Sent: Monday, March 19, 2012 3:46 PM > >range tempat rumus ditulis (dlm contoh D30:H34) >hendaknya diformat custom: General;General;;@ > >sebainya jangan langsung Tanya "maksudnya apa" tapi pelajari dulu >'Custom Number Formatting' yg dapat anda unduh di milis FILES >http://tech.groups.yahoo.com/group/belajar-excel/files/ > >warning: >agar dipertimbangan lagi range yg diberinama 'datalist' >apakah tidak terlalu luas (nantinya akan berpengaruh buruk terhadap >kinerja worksheet) > >o'Seno
