Thanks o'Seno formulanya berfungsi dengan baik ________________________________ Henry Norris Sitohang Mail : [email protected] [email protected] [email protected] Mobile : 081384056896
________________________________ From: o' Seno <[email protected]> To: [email protected] Sent: Thursday, January 5, 2012 1:37 AM Subject: Re: [belajar-excel] Formula VLOOKUP Kalau harus pakai VLOOKUP(yg contohnya tidak diperlihatkan ke sini (??!!)) =IF(VLOOKUP(B3,Sheet1!$B$2:$C$11,2,FALSE)=0,"", VLOOKUP(B3,Sheet1!$B$2:$C$11,2,FALSE)) o'Seno 2012/1/5 o' Seno <[email protected]> > > rumus rujukannya (ditulis di Shee2 Cell A1) > =Sheet1!A1 > > nah,...gantilah dengan > > =IF(Sheet1!A1="","",Sheet1!A1) > > 2012/1/5 Henry Sitohang <[email protected]> >> >> Bagaiman solusi (Formulanya): >> No. Nama NPWP >> 1 Iman 01.470.520-4.414.000 >> 2 Adi >> Jika saya pindahkan ke sheet lain item 2 hasilnya adalah 000000000000 >> sementara yang saya inginkan adalah blank alias kosong
