VLookup Excel Formula Ka Use Kaise Kare – VLookup Tutorial

Vlookup excel formula ka use kaise kare aaj ki iss post me mein aapko batane wala hu. To agar aap microsoft excel ka use karte hai aur vlookup ke use ke bare me janana chahte hai to aaj ki ye post aapke liye hi hai.

V-lookup means verticle lookup aur ye formula mostly table me up, down condition me use hota hai. Vlookup excel formula use karke aap apne ghanto ke kam ko minutes me finish kar sakte hai. Aur isse aap apna kafi time aur mehnat ko save kar sakte hai.

Microsoft excel me vlookup formula ka use aap kai tariko se kar sakte hai. Ye ek aisa excel function hai jiski help se aap apni excel worksheet me kisi table ke specific column me data retrieve kar sakte ho. Aur excel worksheet me vlookup formula ka use karke aap approximate or exact match value show kar sakte hai.

Jaise ki maine aapko upar bataya ki vlooup excel formula ka use kai tarah se kar sakte hai. Lekin mein yahapar aapko vo sabhi tarike nahi batane wala hu kyuki isse post kafi badi ho jayegi. Isliye iss vlookup totorial me mein aapko exam me students ke obtained mark ke base par unko kya grade mila hai.

Kaunsa student fail or kaun pass hai, ya fir kisne top kiya hai in sabhi result ko aap student ke total mark ke base par microsoft excel worksheet me ek minute me kaise show kar sakte hai, chaliye iss vlookup tutorial me janate hai.

VLookup Excel Formula Ka Use Kaise Kare – VLookup Tutorial

Jaise ki aap niche image me dekh sakte hai excel worksheet me ek table hai. Jisme students name hai aur unke obtained marks hai. Aur obtained marks ke according student ka kya result hai chaliye samajhte hai.

  1. Students ke per subject or total marks aur average.
  2. Average ke according result yaha show hoga.
  3. Criteria jiske through vlookup formula result show karega. Criteria me aap dekh sakte hai 0-35% average wala student Fail hai. 35-50% C grade, 50-75% B grade, 75-100% A grade aur 100+% A+ grade ke liye hai.

To ab students ki average ke according uska result show karne ke liye Result column me ek vlookup formula lagana hai. Vlookup example formula kuch iss tarah se hoga.

 

Upar vlookup example ke according aap dekh sakte hai humne result colum me vlookup formula add kiya hai. Issi tarah se aapko jiss cell me result show karna hai usme vlookup formula lagane ke liye sabse pehle:-

  1. =vlookup type karna hai.
  2. lookup_value for example Ave.
  3. table_arrey for example Criteria. Table arrey ko select karna hai aur F4 key press kar fridge karna hai.
  4. col_index_num for example criteria table ke 2nd column result me show karna hai.
  5. [range_lookup] approximate match ke liye 1 type karna hai aur exact match ke liye 2. Hume approximate chahiye isliye 1 key karna hai.
  6. (bracket aur  ,comma as per source lagana hai.

First cell me Vlookup formula key karne ke baad ab bottom cell me isko paste kar dena hai. Jaise hi sabhi result cell me ye excel vlookup formula paste ho jayega to result kuch iss tarah se hoga jaise ki niche image me dekh sakte hai.

Lijiye aap dekh sakte hai Result column me formula paste hote hi sabhi students ke result show ho chuke hai. Jaise ki first student ka B grade hai, 2nd ka A grade, 3rd ka bhi B grade, 4th ka A grade aur 5th student ka C grade aaya hai. Aur sabhi students ke obtained marks 35 se above hai isliye koi bhi fail nahi hua hai.

So ye ek example hai microsoft excel worksheet me vlookup formula ka istemal karne ke liye. Issi tarah se aap alag alag tarike se apni excel worksheet me vlookup command ka use kar sakte hai. Aur excel me apne lengthy work ko easy kar sakte hai.

I hope, microsoft excel worksheet me vlookup formula ka use kaise karte hai ab aap samajh hi gaye honge. Agar aapka koi saval ya sujhav hai to niche comment box me puch sakte hai. Aur agar aapko ye vlookup tutorial pasand aaya ho to isse social sites par apne friends ke sath bhi share jarur kare.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.