How We Should Use Vlookup Function In Microsoft Excel 2007, 2003 With Urdu Hindi Translation

How We Should Use Vlookup Function In Microsoft Excel 2007/2003 With Urdu Translation

Ager ap ki job ka mostly task Microsoft excel ke usage pe hai to phir aj nahi to kal ap ko zaroor zarorat pare ga Vlookup function ki.


Vlookup mein  V ka meaning vertical se hai aur lookup ka meanings search karne ke hain. So, the actual meaning of Vlookup is “column wise search”.

Issi tarah Microsoft excel 2007 mein aik aur formula bhi use kiya jata hai jis ka function Vlookup ke equal hai lakin horizontally matlab ye ke row wise, is ko hlookup function kaha jata hai aur ye sister function hai Vlookup ka. Anyhow, hamari discussion Vlookup pe ho rahi hai so ham ussi ko continue karte hain.

=Vlookup(lookup value, table where value reside, column number where values are located, false)
Vlookup means we are calling Vlookup function, aur jo brackets mein hai ham thora is pe detail mein baat karte hain.
1.Lookup Value: is ka matlab wo value jis ki value hamein chahye.
2.Table where value reside: is ka matlab wo values hain jo aik table mein 2 ya 2 se zayada columns mein pari hain.     For example ager values 2 columns mein pari hain to ham both columns ke wo tamam cells select karein ge jin mein     values/records pare hain. (Note: ham jis value ki value lena chah rahe hain us ko is table mein hona chahye, coz     first of all this function will match value with in table then it will show result other wise it will show null value or N/A)
3.Column # where values are located: is ka matlab wo column hai jahan ap ki required value pari howi hai jo ap ko chahye. (Note: jaise ke ham pehle bata chuke hain ke jo value chahye hai wo table mein bhi mojod ho, issi base pe ye function us ki next value utha ke show kare ga)
4.False: is ka matlab exact value lene ke hain. (Note: ager ham False ki jagah True select kar lein to true function hamein exact value nahi de ga but milti julti value show kare ga. lakin ager value exact chahye to phir false hi select karna pare ga)

For your easiness, please review this diagram. Is se ap ko behter maddad miley gi.

microsoft excel vlookup function

Check Also

Do’s and Don’ts while composing CV Or Resume

CV Do’s: Comprehensive CV: Take two to three days to compose your CV. The biggest ...


  1. Dear Sir,
    Mai vlookup,hlookup,pivot table ,if condition ,system controll ,mail merge ke baren mein detail mein Apka messege hindi mein janana chahta hoon. So reply me soon.

    best of luck
    Dear sir,
    by Rajesh kumar
    date 02/02/2011

  2. v lookup formula in excel


  4. Dear sir
    Vlookup kaise or kab lgaya jata hai or isse hamare seet me kya bdlav aata hai please tell me.

Leave a Reply

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