Sekilas sih pake VLOOKUP, tapi trs yg mau dimunculin di C apa ya?
On 11/25/05, qpass <[EMAIL PROTECTED]> wrote: > > ok real datanya spt ini > > A B C > 01010-31845 02777-00218 > 01010-51255 04065-09030 > 02777-00218 01010-31845 > 04065-09030 01010-51255 > > maksud Saya....gimana caranya untuk menemukan data di B berdasarkan isi > dari > A (misal 01010-31845) kemudian hasilnya masuk ke C dengan row yang sama. > > > ----- Original Message ----- > From: "Setyo Suhartanto" <[EMAIL PROTECTED]> > To: <ITCENTER@yahoogroups.com> > Sent: Friday, November 25, 2005 8:46 AM > Subject: Re: [ITCENTER] formula di Excel > > > Iya nih, setuju ma Agoes. > Kalo cuma gitu, =A udah selesai. > > On 11/25/05, Agoes Boedi Poerwanto <[EMAIL PROTECTED]> wrote: > > > > Nah, kalau hasilnya begini banyak kemungkinannya. Secara gampang Cn=An > > :-). > > Tapi kalau ada suatu fungsi khusus untuk mendapatkannya, mungkin fungsi > > 'IF' > > bisa membantu. > > > > Salam, > > Agoes > > > > ----- Original Message ----- > > From: "qpass" <[EMAIL PROTECTED]> > > To: <ITCENTER@yahoogroups.com> > > Sent: Thursday, November 24, 2005 8:57 AM > > Subject: [ITCENTER] formula di Excel > > > > > > > Sya punya masalah dengan excel begini ceritanya: > > > > > > kolom A B C > > > 11 22 > > > 22 11 > > > Hasil yang diinginkan > > > > > > A B C > > > 11 22 11 > > > 22 11 22 > > > > > > gimana caranya yah selian short ini contoh gampanya aja.. > > > di C menggunakan function Vlook upkah ...? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, > > Gabung, > > > Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian > yang > > > tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs## > > > Bursa: itcenter.or.id/bursa ## > > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > Få Yahoo! Mail med 6 mb lagerplads, spamfilter og virusscan. > > http://dk.mail.yahoo.com > > > > > > -- > > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/