Iya, saya pake MS 2007, hasilnya di 2003 masih belum tahu. Selama ini saya pake formula yang tadi Pak Anton. Makasih atas masukannya, Pak. Saya coba pake formula dari Pak Anton.
From: [email protected] [mailto:[email protected]] On Behalf Of anton suryadi Sent: 23 Nopember 2009 13:19 To: [email protected] Subject: Re: [belajar-excel] ganti #N/A atau, =LOOKUP("z",CHOOSE({1,2},"off",VLOOKUP(G11,$B$4:$C$10,2,0)&""))) >semoga bermanfaat _____ From: anton suryadi <[email protected]> To: [email protected] Sent: Mon, November 23, 2009 1:13:38 PM Subject: Re: [belajar-excel] ganti #N/A jika versinya sebelum excel 2007, biasanya menggunakan formula berikut ini: =IF(ISNA(VLOOKUP(G11,$B$4:$C$10,2,0)),"off",VLOOKUP(G11,$B$4:$C$10,2,0)) atau, =LOOKUP("z",CHOOSE({1,2},"off",TEXT(VLOOKUP(G11,$B$4:$C$10,2,0),0))) >semoga bermanfaat _____ From: Gilang Sedar|SPV Admin|Parastar <[email protected]> To: [email protected] Sent: Mon, November 23, 2009 10:30:39 AM Subject: RE: [belajar-excel] ganti #N/A Dear Pak Faisal, Apakah hasil yang diminta seperti ini ??? Lihat di attachment Formula yang dipakai seperti dibawah ini : =IFERROR(VLOOKUP(G11;$B$4:$C$10;2;FALSE);0) Semoga dapat membantu, Nganggo XL Pastine Jaringan Handal Rekkkk Best Regards PARASTAR ECHORINDO |A. G. Sedar | Head Admin | Parastar Team SBY | 081 839 9662 My another e-mail address : <mailto:[email protected]> [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Faisal Hasman Sent: 23 Nopember 2009 9:53 To: excel Subject: [belajar-excel] ganti #N/A dear master excel tolong dibantu gimana caranya data yang tidak ditemukan menggunakan vlookup (sesuai file _____ New Email names for you! <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.prom otions.yahoo.com/newdomains/aa/> Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does!
<<image001.jpg>>
