HLOOKUP

June 9, 2008 at 10:13 am 6 comments

Menyambung tulisan VLOOKUP, di mana pencarian berbentuk vertikal (kolom), maka HLOOKUP akan mencari dalam bentuk horizontal (kolom). Sama saja dengan VLOOKUP namun, perbedaannya di nilai yg dicari berada di baris pertama (kalau VLOOKUP di kolom pertama).

HLOOKUP(nilai yg dicari, di tabel referensi, nomor baris yg dikembalikan nilanya, boolean apakah mau dicari angka terdekat)

hlookup.jpg

Ini seperti contoh yg VLOOKUP, dengan kasus yg sama, di mana di cell C6, C7 dan C8 beruturut-turut berisi formula berikut:

=HLOOKUP(B6, C2:H3, 2, FALSE)
=HLOOKUP(B7, C2:H3, 2, FALSE)
=HLOOKUP(B8, C2:H3, 2, TRUE)

Silakan pelajari sendiri….

Entry filed under: Formula, Gampang. Tags: .

Evaluasi Jawaban Bekerja Efisien dengan Excel

6 Comments Add your own

  • 1. atjhunk  |  July 15, 2008 at 12:34 am

    Thanks for your tutorial. GBU🙂.

    Reply
  • 2. Mang Kumlod  |  July 15, 2008 at 12:39 am

    You’re welcome!

    Reply
  • 3. d3e5i  |  October 29, 2008 at 8:19 pm

    9898+4

    XQ said:
    Maqsot lo…? :mrgreen:
    Ngga ada apa2 tuh gw tulis gituan…

    Reply
  • 4. Soglon  |  December 22, 2008 at 4:08 pm

    Semoga terus membagikan ilmunya. . . tks Bro

    Reply
  • 5. Lina  |  November 3, 2009 at 12:12 pm

    I love this blog so much

    Reply
  • 6. ahmad  |  January 14, 2010 at 6:48 pm

    wah informasinya kg informatif tif keapa ya ?? padahal sayang posting annya.

    XQ said:
    berarti anda harus baca artikel yang terkait karena saya males bahas hal yg sama.

    Reply

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

Trackback this post  |  Subscribe to the comments via RSS Feed


We Moved!

Kami telah pindah ke www.excelquotient.com

Tweet XQ

Kapsul XQ Terkini

Archives

Annex


Langganan
RSS Kapsul XQ
RSS Komentar XQ

# Blog Walkers
web tracker

Ranks
My Popularity (by popuri.us)

Lisensi
Creative Commons License

%d bloggers like this: