RE: ]] XL-mania [[ menghilangkan #N/A

Dear Boss Ketut Santosa,

Coba pakai rumus iserror, yaitu :

=if(iserror(vlookup(xx,xx,xx,xx),””, vlookup(xx,xx,xx,xx))

 

Sample :

IF(ISERROR(VLOOKUP(D6,Database!B6:C140,2,0)),"",VLOOKUP(D6,Database!B6:C140,2,0))

 

Sudah saya aplikasikan di attachment

 

Best Regards & Thank You

 

            Marthien

" Do all the goods you can, All the best you can, In all times you can, In all places you can, For all the creatures you can..."

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of ketut santosa
Sent: Thursday, November 22, 2012 10:55 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ menghilangkan #N/A

 

 

Dear master..

 

Pak saya baru belajar formula excel..

Saya ada kendala untuk hide/hilangkan #N/A pada formula VLookup

saya coba pake if dan isna..kok ga mau...mohon bantuannya

saya attachan file xls (nama sheetnya:incoming)

 

trimaksih sebelumnya