angka satunya kehapus mungkin.. =IF(L14="FIN",L14,(VLOOKUP(J14,Anggaran!$A$12:$F$5000,6,TRUE)))
blessings, tomz From: Danang Wijaya Sent: Tuesday, January 01, 2013 1:49 PM To: xlmania Subject: ]] XL-mania [[ =IF(L14="FIN",L14,(VLOOKUP(J4,Anggaran!$A$12:$F$5000,6,TRUE))) yg muncul N/A para suhu xl, mohon bantu. saya sdh coba utak atik, tapi mentok. =IF(L14="FIN",L14,(VLOOKUP(J4,Anggaran!$A$12:$F$5000,6,TRUE))) yg muncul N/A file terlampir. terimakasih. salam, danang wijaya.
