Jifunze Excel HLOOKUP(): Kutafuta Data Kwenye Row Haraka

Gundua jinsi ya kutumia HLOOKUP() kwenye Excel kutafuta data haraka kwenye row. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. HLOOKUP() Function

HLOOKUP() inatumika kutafuta thamani kwenye row ya kwanza ya table na kurudisha thamani inayolingana kutoka row nyingine kwenye column ile ile.

Syntax:

HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

lookup_value = thamani unayotafuta

table_array = range ya data unayotafuta ndani yake

row_index_num = namba ya row unayotaka kurudisha matokeo kutoka

range_lookup = TRUE (approximate match) au FALSE (exact match)

2. Mfano Rahisi

Mfano 1: Kutafuta price ya bidhaa kulingana na code

Code P001 P002 P003
Price 100 150 200

Formula:

=HLOOKUP("P002", A1:D2, 2, FALSE)

Result: 150

HLOOKUP inatafuta "P002" kwenye row ya kwanza na kurudisha price kutoka row ya 2.

3. Kutumia HLOOKUP() na IFERROR()

Ili kuondoa error kama lookup_value haipo:

=IFERROR(HLOOKUP("P005", A1:D2, 2, FALSE), "Not Found")

Result: Not Found

4. Kutumia HLOOKUP() Pamoja na AND()/OR()

Unaweza kutumia HLOOKUP() kuunda masharti changamano:
Mfano: Angalia stock ya bidhaa

=IF(OR(HLOOKUP(C1, ProductTable!A1:D2, 2, FALSE)=0, HLOOKUP(C1, ProductTable!A1:D2, 3, FALSE)="Out of Stock"), "Not Ready", "Ready")

C1 = Product Code

ProductTable!A1:D2 ina row ya Codes, Quantity, Status

5. Tips Muhimu

Row ya kwanza lazima iwe sorted ikiwa unatumia range_lookup=TRUE.

Kutumia FALSE kwa range_lookup ni sahihi zaidi kwa data halisi.

IFERROR() inasaidia kurudisha matokeo safi badala ya #N/A.

HLOOKUP() inaweza kuunganisha na AND(), OR(), SWITCH() na IF() kwa reports changamano.

Links Muhimu

Tazama tutorials zaidi za Excel: https://www.faulink.com

Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php

Msaada wa WhatsApp: https://wa.me/255693118509