Halo Shenly;

Coba begini:
=IF(COUNTIF($A$3:$A$28,D3),0,B3)

Copas kebawah


Wassalam

~ Bagus ~



  ----- Original Message ----- 
  From: Shenly 
  To: belajar-excel@yahoogroups.com 
  Sent: Tuesday, February 25, 2014 5:57 PM
  Subject: [belajar-excel] cocokan data dari dua tabel? [1 Attachment]


    

  halo master...tolong di bantu bagaimana caranya mencocokan data dari beberapa 
tabel
  file terlampir. terima kasih

  Salam
  Shenly ^^*

  

Kirim email ke