+ Reply to Thread
Results 1 to 12 of 12

If match found Bothe sheet then put match data.

  1. 03-04-2016, 02:52 PM #1
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Post If match found Bothe sheet then put match data.

    Hi everyone
    If sheet 2 ID Number (A column) Match with Sheet 1 ID Number (A column) then put the name in name column (B column) of sheet 2 automatically.
    Last edited by sumanc6; 03-04-2016 at 03:18 PM.
    Reply With QuoteRegister To Reply
  2. 03-04-2016, 03:46 PM #2
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: If match found Bothe sheet then put match data.

    assuming sheet 1 column A is ID number and Column B is the name then use this formula in sheet 2 cell B2:

    =VLOOKUP(A2,Sheet1!A:B,2,FALSE)
    Reply With QuoteRegister To Reply
  3. 03-04-2016, 04:19 PM #3
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Re: If match found Bothe sheet then put match data.

    Any other option or Formula???
    Reply With QuoteRegister To Reply
  4. 03-04-2016, 04:35 PM #4
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: If match found Bothe sheet then put match data.

    why don't you post a sample worksheet so we have more ideas of what you are looking for specifically.
    Reply With QuoteRegister To Reply
  5. 03-04-2016, 06:48 PM #5
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: If match found Bothe sheet then put match data.

    Quote Originally Posted by sumanc6 View Post
    Any other option or Formula???
    What's wrong with the suggestion you've been given?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  6. 03-05-2016, 01:49 AM #6
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Re: If match found Bothe sheet then put match data.

    I am unable to upload attachment in forum thread.

    Please find the link of sample file

    http://we.tl/1PxDCjF3OP
    Reply With QuoteRegister To Reply
  7. 03-05-2016, 01:54 AM #7
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Re: If match found Bothe sheet then put match data.

    Quote Originally Posted by Tony Valko View Post
    What's wrong with the suggestion you've been given?
    I found match in manually (ctrl+F), But formula show me #N/A ……
    Reply With QuoteRegister To Reply
  8. 03-05-2016, 02:03 AM #8
    udprocks
    udprocks is offline
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: If match found Bothe sheet then put match data.

    In your workbook in sheet 1 ID column there is many spaces you have to do first trim that column after that do text to column......enter....enter...enter,

    after that formula get work.

    please see the attached file...
    Attached Files Attached Files
    If answer helped you say Thanks by Add Reputation
    Reply With QuoteRegister To Reply
  9. 03-05-2016, 02:39 AM #9
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Re: If match found Bothe sheet then put match data.

    There are any other option to work with untrimmed cell.
    Actually I don’t need to any changed in sheet1.
    Almost 35000 row in actual sheet1 & also contain many more data.
    So please tail me any other formula, VB, Macro Etc…
    Reply With QuoteRegister To Reply
  10. 03-05-2016, 03:10 AM #10
    udprocks
    udprocks is offline
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: If match found Bothe sheet then put match data.

    Then Try this

    =VLOOKUP("*"&A2&"*",sheet1!A:B,2,0)

    see attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 03-05-2016, 04:06 AM #11
    sumanc6
    sumanc6 is offline
    Registered User
    Join Date
    08-24-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    19

    Thumbs up Re: If match found Bothe sheet then put match data.

    Thank you

    My problem now Solved.
    Reply With QuoteRegister To Reply
  12. 03-05-2016, 04:10 AM #12
    udprocks
    udprocks is offline
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: If match found Bothe sheet then put match data.

    Quote Originally Posted by sumanc6 View Post
    Thank you

    My problem now Solved.
    Hi suman,

    thank you for feedback.

    please mark your thread as solved.
    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. [SOLVED] Update Sheet A from Sheet B When a Match is Found
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-04-2014, 05:18 PM
  2. [SOLVED] Match one cell with another, if match found copy adjacent cells
    By Xiophoid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-07-2013, 05:50 AM
  3. Macro to copy data from master sheet if match is found
    By shraddha5 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 02-08-2013, 02:17 AM
  4. [SOLVED] Code needed to move cell value from one sheet to another if match is found.
    By SLIDE1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2012, 07:46 PM
  5. VBA Colour cells in 4th sheet if match found in Sheet1,2 or 3
    By zx142985 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 06:33 AM
  6. Coping cells to another sheet when a match is found
    By E3iron in forum Excel General
    Replies: 2
    Last Post: 10-01-2010, 03:28 AM
  7. is it impossible to match 2 columns & return values from a 3rd when a match is found
    By excel_try in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2008, 04:01 PM

Tags for this Thread

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