Ms Excel me HLookup formula kya hai kaise use karein iss post me hum janenge, so agar aap microsoft excel ka use karte hai aur microsoft excel me horizontal lookkup yani ki h-lookup formula ke bare me detail me janana chahte hai to ye post aapke liye hi hai.
MS Excel mein HLOOKUP ek aisa tool hai jo horizontal yaani ki rows mein rakhe gaye data ko pehchanne aur nikalne mein madad karta hai. Jab hamara saara data columns ke bajaye rows mein faila hota hai, tab yeh function sabse pehli row mein hamari pasand ki cheez ko dhundta hai. Iska sabse zyada fayda tab hota hai jab hamein badi tables se kisi khaas mahine ya category ki jaankari turant nikalni ho.
Ise istemal karte waqt hamein bas us value ko chunna hota hai jise hum dhund rahe hain aur poori table ko select karna hota hai. Iske baad hum woh row number batate hain jahan hamara sahi jawab chhupa hai. Yeh top se niche ki taraf search karta hai aur hamesha sahi data nikal kar deta hai, basharte hamari table sahi tarah se bani ho. Excel mein report taiyar karte waqt yeh ek anivarya skill maani jati hai.
MS Excel mein HLOOKUP Formula Kya Hai?
HLOOKUP ka full form Horizontal Lookup hota hai. Yeh Microsoft Excel ka ek mahatvapurn “Lookup and Reference” function hai jo horizontal data ko handle karne ke liye banaya gaya hai.
Jab aapka data columns ke bajaye rows mein arranged hota hai, tab yeh tool sabse upar wali row mein kisi khaas value ko search karta hai.
Iska kaam us value ko pehli row mein dhundna aur phir uske theek niche wali rows se uska related data nikal kar dena hota hai.
Ise tab istemal kiya jata hai jab humein kisi badi table se mahine, saal ya kisi category ke hisaab se jaankari nikalni ho jo top row mein di gayi ho.
Yeh function top se bottom ki taraf scan karta hai aur sahi row number se hamara jawab fetch karta hai. Microsoft Excel mein data management aur reporting ke liye yeh ek anivarya skill hai jo bade database ko manage karna kaafi aasaan bana deti hai.
HLOOKUP Syntax:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Arguments ka Matlab:
-
lookup_value: Wo value jise aap pehli row mein dhundna chahte hain.
-
table_array: Wo pura range jahan aapka data maujood hai.
-
row_index_num: Wo row number jahan se aapko output chahiye (e.g., 2nd row ya 3rd row).
-
range_lookup: Yeh optional hai. 0 (FALSE) ka matlab “Exact Match” aur 1 (TRUE) ka matlab “Approximate Match” hota hai.
HLOOKUP Kaise Use Karein
Maan lijiye aapke paas ek sales report hai jisme Months (January, February, March) pehli row mein hain aur Sales niche wali rows mein.
| Month | January | February | March |
| Sales | 50,000 | 65,000 | 80,000 |
Agar aapko “February” ki sales dekhni hai, toh step-by-step aise karein:
-
Kisi bhi khali cell mein formula shuru karein:
=HLOOKUP( -
Lookup Value: “February” likhein ya us cell ko select karein jisme February likha ho.
-
Table Array: Puri table select karein (A1 se D2 tak).
-
Row Index: Kyunki “Sales” doosri row mein hai, isliye 2 likhein.
-
Range Lookup: Exact match ke liye 0 likhein.
-
Final Formula:
=HLOOKUP("February", A1:D2, 2, 0)
Enter press karte hi aapko result 65,000 mil jayega.
HLOOKUP vs VLOOKUP: Difference Kya Hai?
| Feature | VLOOKUP | HLOOKUP |
| Direction | Vertical (Columns mein dhundta hai) | Horizontal (Rows mein dhundta hai) |
| Search Path | Left to Right | Top to Bottom |
| Index Type | Column Index Number | Row Index Number |
Conclusion
MS Excel mein HLOOKUP ek behad upyogi formula hai, jo horizontal data management ko asaan banata hai. Agar aapka data rows mein sajeel hai, toh yeh tool aapko ghanto ka kaam seconds mein karne ki takat deta hai.
Iska sahi istemal na sirf aapke samay ki bachat karta hai, balki reporting aur data analysis mein hone wali galtiyon ko bhi kam karta hai.
Sankshipt mein kahein toh, VLOOKUP aur HLOOKUP dono hi Ms Excel ke anivarya ang hain. Jahan VLOOKUP columns ke liye hai, wahin HLOOKUP rows ke liye maharat rakhta hai. In dono formulas ki samajh aapko ek proficient data professional banati hai.
Ummeed hai ki is post ke madhyam se aapne HLOOKUP ko puri tarah samajh liya hoga aur ab aap ise apne daily tasks mein asani se apply kar payenge.