Skip to content

Fungsi HLOOKUP

April 7, 2013

Fungsi HLOOKUP

=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

dimana:

   Argument     Definition of argument
   ---------------------------------------------------------------------

   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.

   row_index    The row 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.

Catatan: Jika range_lookup TRUE atau dihilangkan (untuk perkiraan), nilai-nilai dalam baris pertama dari table_array harus diurutkan dalam urutan naik. Jika range_lookup palsu (untuk pencocokan sama persis), table_array tidak perlu diurutkan.

 

About these ads

From → Pelajaran

Leave a Comment

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

Follow

Get every new post delivered to your Inbox.

Join 1,918 other followers

%d bloggers like this: