Fungsi Vlookup dan Hlookup Pada Ms.Excel

Coba mengingat kembali pelajaran yang pernah didapat pas waktu kuliah dulu. Fungsi-fungsi excel yang sering digunakan atau sering ditemui pada saat bekerja dengan data. Diantaranya yaitu fungsi Vlookup dan Hlookup dimana secara umum susunan formulanya sbb :

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Keterangan :
lookup_value : The value to be found in the first column of the array.
table_array : The table of information in which data is looked up.
col_index : The column number in the table_array for which the matching value should be returned.
range_lookup : It is a logical value that specifies whether you want to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned; in other words, if an exact match is not found, the next largest value that is less than the lookup_value is returned. If FALSE, VLOOKUP finds an exact match. If an exact match is not found, the #N/A error value is returned.

Yuk, kita coba contoh datanya seperti dibawah ini :

   A1: Fruit    B1: Color  
   A2: Kiwi     B2: Green 
   A3: Banana   B3: Yellow 
   A4: Grape    B4: Purple  
   A5: Apple    B5: Red

Untuk melihat hasilnya bisa dengan memasukkan formula dibawah ini pada cell kosong :

=VLOOKUP("Apple";A1:B5;2;FALSE)
=HLOOKUP("Color";A1:B5;3;FALSE)

referensi (http://support.microsoft.com)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s