Dear Mr Guntur,
Coba pakai formula ini : =INDEX(FILE1!$1:$1048576;MATCH(A2;FILE1!$G:$G;0);2) Salam, DD From: [email protected] [belajar-excel] [mailto:[email protected]] Sent: 09 Februari 2015 14:58 To: [email protected] Subject: [belajar-excel] pakai rumus apa ya? help (mods : lookup tengok kiri) [1 Attachment] permisi gan saya mau sedikit bertanya tentang rumus yang pas untuk soal seperti ini... _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
