+ Reply to Thread
Results 1 to 6 of 6

Vlookup with multiple creteria

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    India
    MS-Off Ver
    Excel 97/2003/2007/2010
    Posts
    67

    Arrow Vlookup with multiple creteria

    Hi to all,

    i have list of employee leave details, i need to map it to muster roll,,,

    note: Same employee has taken two three times leave for multiple reason. example 200758 has taken leave for two times for different days... i need to map this memo tour to his attendance (july 1st and 2 nd and also 29th, 30th ,31st of that month)

    Personnel No Name Begin Date End Date Subtype Text
    200680 Rajaraman J 7/26/2013 7/26/2013 Emergency Leave
    200758 Satpute Sunil 6/21/2013 7/2/2013 ODD - Memo Tour
    200758 Satpute Sunil 7/29/2013 8/4/2013 ODD - Memo Tour
    200823 Joshi Atul 6/14/2013 7/3/2013 ODD - Memo Tour
    200823 Joshi Atul 7/16/2013 7/22/2013 ODD - Memo Tour
    200999 Tank Sanjay SHAMJIBHAI 7/12/2013 7/19/2013 ODD - Memo Tour
    200999 Tank Sanjay SHAMJIBHAI 7/5/2013 7/5/2013 ODD Memo tour
    200999 Tank Sanjay SHAMJIBHAI 7/8/2013 7/10/2013 ODD Memo tour
    201026 Deshmukh R V 7/12/2013 7/16/2013 Privilege Leave
    201057 Joshi Ashutosh 7/22/2013 7/31/2013 ODD - Memo Tour
    201072 Joshi Ajit 7/3/2013 7/3/2013 Emergency Leave
    201105 Sathe Sudhir CHANDRAKANT 7/24/2013 7/27/2013 ODD - Memo Tour
    201108 Adhikari Syamal 7/14/2013 7/19/2013 Seminar / Training
    201108 Adhikari Syamal 7/8/2013 7/8/2013 Emergency Leave
    201118 Prakash S Rao 7/11/2013 7/11/2013 ODD - Memo Tour
    201118 Prakash S Rao 7/10/2013 7/10/2013 ODD - Memo Tour
    201439 Lawande Arvind 7/18/2013 7/29/2013 ODD - Memo Tour
    201669 Kamat S M 7/19/2013 7/23/2013 ODD - Memo Tour
    202120 Aravapalli Srinivas 7/1/2013 7/3/2013 ODD - Memo Tour
    202176 Kirty Apurbo 7/1/2013 7/2/2013 ODD - Memo Tour
    202176 Kirty Apurbo 7/17/2013 7/23/2013 ODD - Memo Tour
    202176 Kirty Apurbo 7/29/2013 8/2/2013 ODD - Memo Tour


    Thanks in advance

    regards,
    sathya
    Attached Files Attached Files
    Last edited by sathiyamoorthy; 08-19-2013 at 04:38 AM. Reason: title not clear

  2. #2
    Registered User
    Join Date
    07-09-2012
    Location
    India
    MS-Off Ver
    Excel 97/2003/2007/2010
    Posts
    67

    Re: Vlookup with multiple creteria

    hi to all,

    please help me out... if i am not asked my question clearly, kindly ask me what i want give the details...

    waiting for your kind help.. otherwise i have do it all the data manual entry only...
    regards,

    sathya
    Last edited by sathiyamoorthy; 08-19-2013 at 07:15 AM. Reason: spell mistake

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Vlookup with multiple creteria

    How your data which you have posted related to attached examples?
    Can you clearly state your outcome in one of your spreasheets?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  4. #4
    Registered User
    Join Date
    07-09-2012
    Location
    India
    MS-Off Ver
    Excel 97/2003/2007/2010
    Posts
    67

    Re: Vlookup with multiple creteria

    i have the list like below and find it in attached file "JULY ODD & LEAVE neww" and i need to copy this leave and tour details in muster roll of july month file. i can use the vlook up formula, if i am having name or personnel Number without repeating... some persons are taken different reasonable leaves on different date duration. so how to i copy those details to mustor roll ( attendance)... i have done it by my method. i will upload my attachment with solution i have done. but i need to solve it with some powerful formula.

    Personnel No Name Begin Date End Date Subtype Text
    200680 Rajaraman J 7/26/2013 7/26/2013 Emergency Leave
    200758 Satpute Sunil 6/21/2013 7/2/2013 ODD - Memo Tour
    200758 Satpute Sunil 7/29/2013 8/4/2013 ODD - Memo Tour
    200823 Joshi Atul 6/14/2013 7/3/2013 ODD - Memo Tour
    200823 Joshi Atul 7/16/2013 7/22/2013 ODD - Memo Tour
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Vlookup with multiple creteria

    IN C2 use. Then copy paste to other cells.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-09-2012
    Location
    India
    MS-Off Ver
    Excel 97/2003/2007/2010
    Posts
    67

    Re: Vlookup with multiple creteria

    hi kvsrinivasamurthy sir,

    it is working fine... great work done... can you please explain me how it is working...

    regards,
    sathya

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Getting data from a range matching certain creteria
    By cndesu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2012, 10:00 AM
  2. Count Unique Values With Multiple Creteria.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2012, 11:04 AM
  3. Lock cells based on creteria
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 06:39 PM
  4. Match data with 3 creteria..
    By sid_12 in forum Excel General
    Replies: 3
    Last Post: 07-29-2010, 04:44 AM
  5. Vlookup or macro for multiple creteria
    By Wskip49 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2008, 09:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1