+ Reply to Thread
Results 1 to 6 of 6

2 column matched

  1. 01-11-2019, 06:33 PM #1
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    2 column matched

    Hi Excel Experts,
    I need help in column C if column B entry is available in column A then column C show "Matched" if not available it will show "NOT Matched"

    Thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-11-2019, 06:46 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,377

    Re: 2 column matched

    Cell C2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and copy down
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-11-2019, 06:48 PM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: 2 column matched

    Hi

    C2 and down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  4. 01-12-2019, 12:40 AM #4
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: 2 column matched

    Thank You
    Reply With QuoteRegister To Reply
  5. 01-12-2019, 02:22 AM #5
    AliGW
    AliGW is offline
    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,460

    Re: 2 column matched

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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.
    Reply With QuoteRegister To Reply
  6. 01-12-2019, 03:19 AM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,377

    Re: 2 column matched

    You're welcome. Thanks for the rep.
    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. When first pair are matched, copy entry beside the column to another column
    By seanryano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2015, 11:14 AM
  2. File Open and Search column from A1:CE1. If matched than copy entire row for that column.
    By shivanisachdeva167 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2014, 01:51 PM
  3. 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
  4. 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
  5. 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
  6. Get matched values of a column based on the value of other column
    By Bluecarbon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2009, 09:22 AM
  7. 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 [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 08:15 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