+ Reply to Thread
Results 1 to 2 of 2

Compare 2 cells in an excel sheet

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-03-2009
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    132

    Compare 2 cells in an excel sheet

    Hi,
    My requirement is that, say for example
    i have column A and B in excel. the data is alphanumeric, some cells are blank too.

    In cell c i want to obtain a value called "match" for 2 conditions one if the cells match with value(cell A3 has "MA21" and cell B3 has "MA21") and second if the cells match when both are blank (cell A4="" and Cell B4="".

    If cell A5 is blank and cell b5 has value or if cell A5 has value and does not match with Cell B5 then i want the value to be "no match"
    Thanks
    mp

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Compare 2 cells in an excel sheet

    Hi,

    You can try this formula:

    =IF(A1=B1,"MATCH","NO MATCH")
    Click *, if my suggestion helps you. Have a good day!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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