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
    Join Date
    09 Apr 2009
    Location
    کر&
    Gender
    Male
    Posts
    13,827
    Threads
    224
    Credits
    11,294
    Thanked
    1483

    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
    13,827
    Threads
    224
    Credits
    11,294
    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
    Join Date
    04 Nov 2015
    Gender
    Male
    Posts
    2,604
    Threads
    30
    Credits
    12,040
    Thanked
    165

    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
  •