Cara Menggunakan Fungsi Lookup di Excel

Unduh PDF
Unduh PDF

Saat bekerja di sebuah lembar kerja, akan ada saat Anda ingin mencari informasi tanpa harus menggulir daftar yang panjang. Saat itulah Anda bisa memanfaatkan fungsi LOOKUP. Katakanlah Anda memiliki daftar berisi 1.000 klien dengan tiga kolom: Nama belakang, nomor telepon, dan usia. Untuk mencari nomor telepon Monique wikiHow, misalnya, Anda dapat mencari nama tersebut di dalam kolom lembar kerja. Anda bisa menyortir nama berdasarkan abjad agar lebih cepat. Bagaimana jika ternyata banyak klien yang nama belakangnya dimulai dengan "w"? Perlu ketelitian ekstra dan juga waktu yang cukup lama untuk mencarinya di daftar. Namun, dengan fungsi LOOKUP Anda cukup mengetikkan nama, dan lembar kerja akan menampilkan nomor telepon dan usia untuk orang tersebut. Kedengarannya berguna, bukan?

Langkah

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/62\/Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pada contoh ini, satu kolom memiliki angka dan kolom lainnya memiliki kata-kata acak.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a5\/Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a5\/Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ini adalah sel yang akan menampilkan daftar tarik-turun.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9f\/Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9f\/Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pilih tab DATA pada bilah alat, kemudian pilih VALIDATION.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d3\/Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/86\/Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2d\/Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2d\/Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Kini Anda akan melihat sebuah kotak dengan panah, yang bila diklik akan memunculkan daftar.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3a\/Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3a\/Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6d\/Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/29\/Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/29\/Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sebuah kotak lain akan muncul. Klik OK.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/60\/Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b5\/Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  14. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/31\/Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/31\/Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg\/v4-728px-Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Iklan

Tips

  • Pastikan ketika Anda berada di jendela DATA VALIDATION (Langkah 5) kotak dengan tulisan IN-CELL DROPDOWN dicentang.
  • Setiap kali selesai, Anda dapat mengubah warna huruf menjadi putih untuk menyembunyikan daftar tersebut.
  • Simpanlah pekerjaan secara berkala, terutama jika daftar yang Anda miliki panjang.
  • Jika Anda ingin mengetikkan kata kunci yang ingin dicari, Anda bisa langsung menuju langkah 7.
Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara
Membulatkan Angka di Excel
Iklan

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 8.308 kali.

Apakah artikel ini membantu Anda?

Iklan