Re: ]] XL-mania [[ How with IF dan VLookup

[Ahmad Zamroni]

coba dengan rumus ini: =IF(ISNA(VLOOKUP(A1,hasil!A:B,2,)),B1&" "&C1,VLOOKUP(A1,hasil!A:B,2,)) -zam- ----- Original Message ----- From: Yora Friano To: XL-mania@yahoogroups.com Sent: Friday, April 21, 2006 2:05 PM Subject: ]] XL-mania [[ How with IF dan VLookup Dear all   Mohon bantuan di attach untuk modifikasi IF dengan menggunakan VLOOKUP.   Terima kasih   Salam, Rino +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, | | pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. | +-------------------------------------------------------------------+ | Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" | | Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. | +-------------------------------------------------------------------+ | Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Business application software Microsoft excel training Microsoft excel tutorial Business application development Microsoft excel help Microsoft excel training course YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.