+ Reply to Thread
Results 1 to 8 of 8

Vlookup using 2 column matched

Hybrid View

  1. 05-26-2014, 05:48 AM #1
    lokpal.panwar
    lokpal.panwar is offline
    Registered User
    Join Date
    03-05-2013
    Location
    Beawar (Ajmer)
    MS-Off Ver
    Excel 2016
    Posts
    35

    Vlookup using 2 column matched

    Hello friends,
    In the attached sheet I want TR no. in sheet names TLPL using 2 criteria of truck no. and date.


    Regards,

    lokpal singh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-26-2014, 06:08 AM #2
    Saarang84
    Saarang84 is offline
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Vlookup using 2 column matched

    Hi Lokpal (Aam Aadhmi ?? ),

    I built a helper column and used vlookup to map the values. Check out the attached workbook. I've colored the formulated columns in yellow. Is this what you need?
    Attached Files Attached Files
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang
    Reply With QuoteRegister To Reply
  3. 05-26-2014, 06:11 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Vlookup using 2 column matched

    I think you want the values in column D of sheet 111.xlsx filled in. If not - then what ? I can see that the truck IDs are contained in the value of the string in column B of the TLPL sheet (starting with RJ14GC). However, in your example - where can I find the Tr No (13065) in cell D4 of 111.xlsx?

    I don't think you have supplied enough information yet.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 05-26-2014, 06:20 AM #4
    lokpal.panwar
    lokpal.panwar is offline
    Registered User
    Join Date
    03-05-2013
    Location
    Beawar (Ajmer)
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: Vlookup using 2 column matched

    There are 2 sheets. I want TR no. in column H of sheet TLPL which has to come from sheet 111. Date and truck no. like 5530,6900 should be matched.
    Reply With QuoteRegister To Reply
  5. 05-26-2014, 06:29 AM #5
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Vlookup using 2 column matched

    Hi ,

    was this want u want is?


    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-26-2014, 06:57 AM #6
    lokpal.panwar
    lokpal.panwar is offline
    Registered User
    Join Date
    03-05-2013
    Location
    Beawar (Ajmer)
    MS-Off Ver
    Excel 2016
    Posts
    35

    Red face Re: Vlookup using 2 column matched

    Thanks a lot problem is sort out.

    I will learn this formula.
    Reply With QuoteRegister To Reply
  7. 05-26-2014, 06:50 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Vlookup using 2 column matched

    Wrong answer given in error. I forgot to add in the date criterion. Go with Punnam's solution.
    Last edited by Glenn Kennedy; 05-26-2014 at 06:56 AM.
    Reply With QuoteRegister To Reply
  8. 05-26-2014, 07:11 AM #8
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Vlookup using 2 column matched

    HI lokpal,

    If u r question answered mark the thread as Solved using the Tool.

    Punnam
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find the match in between two column and print the matched corresponding value in column C
    By jassipox in forum Excel General
    Replies: 6
    Last Post: 01-29-2014, 12:22 AM
  2. Search results of a column display a set value in another column if matched
    By rkrause54 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-12-2013, 01:59 PM
  3. Find Max in Single column range IF a condition on different column is matched
    By pkrchari in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-28-2012, 07:49 PM
  4. VLOOKUP no exact matched
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 03-23-2010, 02:16 PM
  5. [SOLVED] How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C
    By genesisoxygen@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 08:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1