Results 1 to 6 of 6

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,606
    Threads
    281
    Credits
    25,576
    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,606
    Threads
    281
    Credits
    25,576
    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. The Following User Says Thank You to malik1984 For This Useful Post:

    sohail yousaf (4th September 2020)

  7. #6
    leezuka389's Avatar
    leezuka389 is offline Advance Member
    Last Online
    Yesterday @ 05:47 PM
    Join Date
    04 Nov 2015
    Gender
    Male
    Posts
    5,925
    Threads
    38
    Credits
    45,215
    Thanked
    294

    Default

    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: 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
  •