Results 1 to 10 of 10

Thread: "VLOOKUP" formula required

  1. #1
    Tania Meer is offline Senior Member+
    Last Online
    23rd May 2019 @ 01:38 PM
    Join Date
    14 Sep 2011
    Gender
    Female
    Posts
    100
    Threads
    10
    Credits
    1,085
    Thanked
    2

    Default "VLOOKUP" formula required

    Dear Experts

    plz let me know how to use the vlookup formula. (pictorial guide required)

    thanks

  2. #2
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 08:57 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,273
    Threads
    411
    Credits
    39,647
    Thanked
    1813

    Default

    Please use Search option solution is here and check Magazines in which complete reply of your question

  3. #3
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 08:57 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,273
    Threads
    411
    Credits
    39,647
    Thanked
    1813

  4. #4
    ammargroup is offline Junior Member
    Last Online
    18th April 2018 @ 03:28 PM
    Join Date
    06 Feb 2018
    Age
    34
    Gender
    Male
    Posts
    28
    Threads
    1
    Credits
    216
    Thanked
    0

    Default

    شکریہ بھائی جزاک اللہُ خیر

  5. #5
    malik1984 is offline Junior Member
    Last Online
    9th December 2018 @ 06:08 PM
    Join Date
    24 Feb 2009
    Posts
    21
    Threads
    1
    Credits
    1,027
    Thanked: 1

    Default

    =VLOOKUP(lookup-value,table_array,index-column,range_lookup)
    Step 1 Lookup value (what u want to search)
    Step 2 Table Array (select the full table from where u want to search)
    Step 3 Col Index Number (give column number in which colm is the value u need ( 2 or 3 or 4 etc)
    lookuprange= put 0 for false,
    false value mean exact match,,,
    true value mean approximate value,
    mostly we will use false for exact match

  6. #6
    leezuka389's Avatar
    leezuka389 is offline Advance Member
    Last Online
    9th August 2023 @ 04:14 PM
    Join Date
    04 Nov 2015
    Gender
    Male
    Posts
    6,596
    Threads
    39
    Credits
    56,449
    Thanked
    294

    Default

    nice

  7. #7
    shahzebjan34 is offline Senior Member+
    Last Online
    23rd September 2023 @ 11:04 PM
    Join Date
    18 Jun 2013
    Location
    Multan
    Gender
    Male
    Posts
    269
    Threads
    6
    Credits
    2,450
    Thanked
    0

    Default


  8. #8
    bilal_hm's Avatar
    bilal_hm is offline Advance Member
    Last Online
    17th December 2023 @ 05:49 PM
    Join Date
    05 Jan 2010
    Location
    ...............
    Gender
    Male
    Posts
    1,219
    Threads
    46
    Credits
    1,595
    Thanked
    56

    Default

    iska work kya hai vlook up ka .... mujhy iski thek sy smjh nhi ayi
    ‎"Everybody in this world loves you for his own interest. Only ALLAH Loves you for your interest."

  9. #9
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 08:57 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,273
    Threads
    411
    Credits
    39,647
    Thanked
    1813

    Default

    Quote bilal_hm said: View Post
    iska work kya hai vlook up ka .... mujhy iski thek sy smjh nhi ayi
    Quote bilal_hm said: View Post
    iska work kya hai vlook up ka .... mujhy iski thek sy smjh nhi ayi
    اس کی مدد سے ہم ایکسل کی دو ورک شیٹ یا دو ورک بُک کی ویلیوز کا موازنہ کر سکتےہیں
    کہ دونوں ویلیوز ایک جیسی ہیں کہ نہیں
    اگر نہیں ہیں تو کون کون سی
    اس کام کو کر کے دیکھیں پھر بہت سے
    آئیڈیاز
    آپ کے زہن میں خود بہ خود آجائیں گے کہ آپ اپنے ڈیٹا کے ساتھ کیا کیا کر سکتے ہیں

  10. #10
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 08:57 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,273
    Threads
    411
    Credits
    39,647
    Thanked
    1813

    Default

    وی ۔۔۔سے مُراد ہوتی ہے
    ورٹیکل
    اور
    lookup
    کا مطلب ہےکہ تلاش کرنا
    یعنی ایکسل میں ورٹیکلی ڈیٹا میں سے کچھ تلاش کرنا

Similar Threads

  1. """"ایک من """"
    By asif.epcl in forum Design Poetry
    Replies: 13
    Last Post: 22nd November 2018, 05:04 PM
  2. Replies: 10
    Last Post: 31st October 2017, 11:15 PM
  3. """""Nokia ki themes ab ap khud bnain"""""
    By Adeel SR in forum Softwares
    Replies: 72
    Last Post: 4th July 2017, 03:16 PM
  4. """"""ہمسفر""""""
    By sheri in forum Urdu Adab & Shayeri
    Replies: 3
    Last Post: 26th October 2016, 09:10 AM
  5. Apni Marzi ka "FONT", "Colour", "Size" ko hamesha k leye select kerna seekhain.
    By Kutkutariyaan in forum New Members Training Center
    Replies: 498
    Last Post: 31st October 2015, 07:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •