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 <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/> Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does!
<<image001.jpg>>
GIE-ganti NA.xls
Description: MS-Excel spreadsheet
