Hot Fox: ]] XL-mania [[ http://www.xl-mania.com/2008/06/vlookup-yang-bisa-nengok-ke-kiri.html

Dear xl-mania
Saya pernah dapat rumus di xl-mania yang fungsinya seperti vlookup, tetapi klo vlookup khan mencari hasil dari suatu kolom terus ke arah kanan kolom.
Nah kemaren saya sempet dapet rumus yg kebalikannya yaitu mencari hasil dari suatu kolom ke "KIRI". Saya cari2 lagi rumusnya koq lupa dimana ya....
Ada yg bisa bantu nggak ya...
Terima kasih atas bantuannya..

Best Regards,
N.7064.S
Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT

------------------------------------

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| oooppsss... 216 e-mails di folder sp4m kepencet [delete] :( |
| 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 |
+-------------------------------------------------------------------+Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/XL-mania/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/XL-mania/join
(Yahoo! ID required)

<*> To change settings via email:
XL-mania-digest@yahoogroups.com
XL-mania-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
XL-mania-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Hot Fox

quinta-feira, 2 de setembro de 2010

]] XL-mania [[ http://www.xl-mania.com/2008/06/vlookup-yang-bisa-nengok-ke-kiri.html

Nenhum comentário:

Arquivo do blog