Atawa pake sumproduct juga bisa kallee…… Use attached file from Master ctv.
=SUMPRODUCT(($D$4:$D$7=$F14)*($A$3:$E$3=G$12)*($A$4:$E$7)) Wassalam, Dikx *he@ ヂヂンコマルヂン _____ From: [email protected] On Behalf Of anton suryadi Sent: Monday, April 26, 2010 9:07 AM To: [email protected] Subject: Re: [belajar-excel] Vlookup pengambilan ke kiri atao coba minta bantuan sodaranya Vlookup yang bisa noleh ke kiri, si Lookup =LOOKUP("a",E1:E5,D1:D5) >semoga bermanfaat
