Webhosting in Pakistan
Results 1 to 6 of 6

Thread: "VLOOKUP" formula required

  1. #1
    Tania Meer is offline Senior Member+
    Last Online
    24th April 2018 @ 02:38 PM
    Join Date
    14 Sep 2011
    Gender
    Female
    Posts
    99
    Threads
    10
    Credits
    598
    Thanked
    2

    Default "VLOOKUP" formula required

    Webhosting in Pakistan
    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 V.I.P
    Last Online
    15th December 2018 @ 12:15 PM
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    13,811
    Threads
    224
    Credits
    11,227
    Thanked
    1483

    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 V.I.P
    Last Online
    15th December 2018 @ 12:15 PM
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    13,811
    Threads
    224
    Credits
    11,227
    Thanked
    1483

  4. #4
    ammargroup is offline Junior Member
    Last Online
    18th April 2018 @ 04:28 PM
    Join Date
    06 Feb 2018
    Age
    28
    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
    551
    Thanked
    0

    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
    Yesterday @ 09:29 PM
    Join Date
    04 Nov 2015
    Gender
    Male
    Posts
    2,547
    Threads
    29
    Credits
    11,764
    Thanked
    164

    Default

    Webhosting in Pakistan
    nice

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: 1st November 2017, 12:15 AM
  3. """""Nokia ki themes ab ap khud bnain"""""
    By Adeel SR in forum Softwares
    Replies: 72
    Last Post: 4th July 2017, 04:16 PM
  4. """"""ہمسفر""""""
    By sheri in forum Urdu Adab & Shayeri
    Replies: 3
    Last Post: 26th October 2016, 10: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, 08: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
  •