Results 1 to 7 of 7

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
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    16,877
    Threads
    298
    Credits
    26,511
    Thanked
    1813

    Default

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

  3. #3
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    16,877
    Threads
    298
    Credits
    26,511
    Thanked
    1813

  4. #4
    ammargroup is offline Junior Member
    Last Online
    18th April 2018 @ 03:28 PM
    Join Date
    06 Feb 2018
    Age
    31
    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
    Join Date
    04 Nov 2015
    Gender
    Male
    Posts
    6,044
    Threads
    38
    Credits
    48,668
    Thanked
    294

    Default

    nice

  7. #7
    shahzebjan34 is offline Senior Member+
    Last Online
    7th May 2021 @ 05:39 AM
    Join Date
    18 Jun 2013
    Location
    Multan
    Gender
    Male
    Posts
    234
    Threads
    1
    Credits
    2,071
    Thanked
    0

    Default


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
  •