Jinsi ya Kutumia Excel Formula INDEX na MATCH Kutafuta Thamani

Unataka kupata thamani ya seli fulani kulingana na sharti au lookup? Formula =INDEX(L$2:L$30,MATCH($M6,$L$2:$L$30,0)) ni mchanganyiko bora wa INDEX na MATCH unaokuwezesha kupata data kwa usahihi bila kutumia VLOOKUP. Ni rahisi, haraka, na inafanya kazi hata kama safu ya lookup si ya kwanza.

📘 Formula
=INDEX(L$2:L$30,MATCH($M6,$L$2:$L$30,0))

🔹 Maelezo ya Formula

L$2:L$30 → Safu ya data unayotaka kurudisha thamani kutoka.

MATCH($M6,$L$2:$L$30,0) → Inatafuta nafasi ya kwanza ambapo thamani ya M6 inalingana na seli kwenye safu L2:L30.

INDEX → Inarudisha thamani inayopatikana kwenye nafasi hiyo.

🔹 Mfano Rahisi
L2 L3 L4 L5 L6 M6 =INDEX(L$2:L$30,MATCH($M6,$L$2:$L$30,0))
A B C D E C C

Hapa, formula inatafuta C kwenye safu L2:L6 na inarudisha thamani C.

🔗 Links Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Excel Mifumo – Ready to Use:
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509