Results 1 to 2 of 2

Thread: vlookup functionality

  1. #1
    nimrah_khan is offline Senior Member+
    Last Online
    27th September 2013 @ 07:59 AM
    Join Date
    11 Dec 2010
    Age
    39
    Gender
    Female
    Posts
    413
    Threads
    114
    Credits
    0
    Thanked
    3

    Default vlookup functionality

    how to use vlookup?

    if i have 3 column in sheet a and 3 column in sheet b, i want to match 3 column in sheet with 3 column in sheet b.How ?

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote nimrah_khan said: View Post
    how to use vlookup?

    if i have 3 column in sheet a and 3 column in sheet b, i want to match 3 column in sheet with 3 column in sheet b.How ?
    There are quite few methods to match data with each other. Aap k pechly thread m m n aap ko aik specif thread suggest kya tha lkn shyad aap use follow na kr sake.

    Jab aap n 3 columns ko match krna ho tu aap apne 3 columns ko concatenate kr lain. Assume COLUMN A+B+C has your data. in column D of both sheets
    =A1&B&&C1

    Now in D1 you can apply multiple formulas. YOu can use match function, vlookup with if combination. please stduy the attached sheet. jo aap ko smjh na aae tu phir poch lain. ya in formulas ko apni marzi k mutabiq enhance kr lain.

    regards
    Attached Files Attached Files

Similar Threads

  1. Dear Xls Experts Mujhe VLOOKUP wala Faomula Samjhna Hay
    By balalnasir in forum Ask an Expert
    Replies: 8
    Last Post: 31st March 2017, 05:05 PM
  2. Solved vlookup and hlookup .....
    By arifraza in forum Solved Problems (IT)
    Replies: 7
    Last Post: 10th October 2011, 11:47 AM
  3. kia es main vlookup lag sakta hay
    By sabir sami in forum Ask an Expert
    Replies: 1
    Last Post: 12th August 2011, 05:56 AM
  4. excel main vlookup or hlookup kaise use kartai hain
    By toolplaza in forum Ask an Expert
    Replies: 1
    Last Post: 12th June 2011, 02:19 PM
  5. Excel Vlookup help
    By sajidbagi in forum Ask an Expert
    Replies: 2
    Last Post: 20th July 2009, 10:47 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
  •