jika versinya sebelum excel 2007, biasanya menggunakan formula berikut ini:
=IF(ISNA(VLOOKUP(G11,$B$4:$C$10,2,0)),"off",VLOOKUP(G11,$B$4:$C$10,2,0))
atau,
=LOOKUP("z",CHOOSE({1,2},"off",TEXT(VLOOKUP(G11,$B$4:$C$10,2,0),0)))
>semoga bermanfaat
From: Gilang Sedar|SPV Admin|Parastar <[email protected]>
To: [email protected]
Sent: Mon, November 23, 2009 10:30:39 AM
Subject: RE: [belajar-excel] ganti #N/A
Dear Pak Faisal,
Apakah hasil yang diminta seperti ini ???
Lihat di attachment
Formula yang dipakai seperti dibawah ini :
=IFERROR(VLOOKUP(G11;$B$4:$C$10;2;FALSE);0)
Semoga dapat membantu,
Nganggo XL Pastine Jaringan Handal Rekkkk
Best Regards
PARASTAR ECHORINDO |A. G. Sedar | Head Admin | Parastar Team SBY | 081 839 9662
My another e-mail address : [email protected]
From: [email protected]
[mailto:[email protected]] On Behalf Of Faisal Hasman
Sent: 23 Nopember 2009 9:53
To: excel
Subject: [belajar-excel] ganti #N/A
|
dear master excel |
New
Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
