RE: ]] XL-mania [[ vlookup VS titik jadi error

 

Hi Denys,

 

Saya coba menjawab dengan menggunakan 1 kolom helper pada kolom B (bisa di hide)

File terlampir

 

 

Regards,

Candra

+607-6612384

P  Please consider the environment before printing this mail !

---

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Deny Syarifudin
Sent: Monday, May 09, 2011 3:10 PM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ vlookup VS titik jadi error

 

 

 

 

Dear master Excel,

Saya menggunakan Excel 2007, dan mempunyai kasus yang agak rumit ketika menggunakan vlookup.

kasusnya seperti ini,

saya mau mengambil data dari tabel 1 dan disimpan di tabel 2 dengan menggunakan vlookup tetapi hasilnya tidak sesuai dengan yang seharusnya/saya harapkan, karena cell yg dijadikan vlookup_value nya telah ada perubahan format yang asalnya 24.123.2.32 saya ubah menjadi 24123232 (tanda titiknya di hilangkan dengan menggunakan perintah clean atau substitute).

mohon bantuannya dari master².
contoh file terlampir.

Tks.
denys

 

********************************************************************** CONFIDENTIALITY CAUTION :  This email is intended only for the use of the individual or entity to whom it is addressed and contains information that is confidential and may also be privileged. If you, the reader of this email, are not the intended recipient, you are strictly prohibited from disseminating, distributing, copying, disclosing or in any way use or rely on information contained in this email or any attachment. If you have received this email in error, please notify us immediately by return email and delete the original email including any attachment.  www.beyonics.com **********************************************************************  

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 84

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| maaf baru moderate sekarang... momods kurang tidur berhari-hari   |
| jadi budak kantoooOOooorrr...                                     |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| 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  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___