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)
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>>
vlookup and match_VD.xls
Description: MS-Excel spreadsheet
