Closed Thread
Results 1 to 7 of 7

Match 2excel and display the output

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Match 2excel and display the output

    In attached excel sheet i want to match 2excel sheet and output will be display in sheet2 as mentioned output in sheet2
    Attached Files Attached Files
    Last edited by maddyrafi1987; 10-13-2018 at 12:22 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Match 2excel and display the output

    No. You will need to explain the logic behind your expected answers...
    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Match 2excel and display the output

    This has been cross-posted on at least one other forum.

    Maddy - you know the rules. Please provide cross-post links. Until this has been done, I am afraid we will not help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Match 2excel and display the output

    i want to match the records from excel sheet1 to excel sheet 2, common is borrower id, in 2sheets borrower id and product type was same means then in sheet2 product type it was remain the same in that cell, suppose if was mismatch then it want to replace data from sheet1, suppose new data was here in sheet2 and in sheet1 it was not available means then in sheet2 it was remain the same

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Match 2excel and display the output

    Maddy - you have a history of ignoring moderation requests. If you ignore post #3, then I shall ban you from these forums.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Match 2excel and display the output

    OK. That's clear. I am now sitting back waiting for you to comply with Ali's request.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Match 2excel and display the output

    As Maddy has made no attempt at all to comply with the moderation request, and this is now the third time he has chosen to ignore such directions, I am closing this thread.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display the Output in Textbox
    By Biplab1985 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-03-2015, 12:31 PM
  2. [SOLVED] INDEX MATCH Multiple Output with Partial Match
    By Ray Storm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2015, 12:05 AM
  3. it is not display any output when i run macro
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-10-2014, 05:24 AM
  4. Replies: 3
    Last Post: 07-26-2013, 06:46 PM
  5. [SOLVED] Match text in 2 columns, if true output adjacent cell to the match.
    By kenoboy in forum Excel General
    Replies: 3
    Last Post: 07-03-2012, 09:52 AM
  6. [SOLVED] How to look up two values then display an output?
    By ohlalayeah in forum Excel General
    Replies: 1
    Last Post: 06-04-2012, 01:53 AM
  7. Excel 2007 : Display output from a row of data
    By MarginofBuffett in forum Excel General
    Replies: 9
    Last Post: 11-18-2010, 09:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1