sorry rek... Ada sedikit kesalahan.. Melihat lg rumus sebelumnya, kalo tebal perhitungan < tebal standart minimum ---> ternyata nggak keluar hasil.. hehehe sorry bos.. Nih aku kirim lagi revisi rumusnya, tapi yg ini array formula..
=INDEX($C$2:$P$31,MATCH(B36,$B$2:$B$31,0),MATCH(FALSE,OFFSET($C$1:$P$1,MATCH(B36,$B$2:$B$31,0),)<B37,-1)) atau =INDEX($C$2:$P$31,MATCH(B36,$B$2:$B$31,0),MATCH(0,((OFFSET($C$1:$P$1,MATCH(B36,$B$2:$B$31,0),))<B37)*1,-1)) eksekusi dgn Ctrl+Shift+Enter cheers, VD Vidi Ardyanto/TJ0987/JOC/ID 02/25/2009 11:34 AM To [email protected] cc Subject Re: ]] XL-mania [[ vlookup and match Salah satu alternative bisa pake formula berikut : =INDEX($C$2:$P$31,MATCH(B36,$B$2:$B$31,0),MATCH(B37,OFFSET($C$1:$P$1,MATCH(B36,$B$2:$B$31,0),),1)+1) [attachment "vlookup and match_VD.xls" deleted by Vidi Ardyanto/TJ0987/JOC/ID] cheers, VD aap ap <[email protected]> Sent by: [email protected] 02/24/2009 08:02 PM Please respond to [email protected] To [email protected] cc Subject ]] XL-mania [[ vlookup and match dear para master excel newbie ada beberapa masalah nih(lebih lengkapnya lihat di attachment ya) mohon bantuannya dan terima kasih salam, tyo [attachment "vlookup and match.xls" deleted by Vidi Ardyanto/TJ0987/JOC/ID]
<<image/gif>>
<<image/gif>>
<<image/gif>>
