+ Reply to Thread
Results 1 to 4 of 4

If 2 cells do not match produce a message

Hybrid View

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    If 2 cells do not match produce a message

    Hi Guys

    I have 2 cells which will each have a post code in so below is an example


    A2 = RM3 0

    A3 = AB10 0


    now because the 2 above do not match i would like the message REFER TO UNDERWRITING to show in cell A4



    please could you let me know how to do this


    Rick

  2. #2
    Registered User
    Join Date
    05-28-2010
    Location
    London
    MS-Off Ver
    MS365 (PC) Version 2301
    Posts
    92

    Re: If 2 cells do not match produce a message

    in cell A4 put

    =IF(A2=A3,"","Refer to Underwriting")

    basically says "If A2 is the same as A3 say "nothing", otherwise say "Refer to underwriting"

    or I think you can say

    if(A2<>A3,"Refer to underwriting"

    which means, "if it doesn't equal the same as"

  3. #3
    Registered User
    Join Date
    05-03-2012
    Location
    Christchurch, New Zealand
    MS-Off Ver
    Excel 2003, 2010
    Posts
    14

    Re: If 2 cells do not match produce a message

    Hi there:

    =IF(A2=A3,"","REFER TO UNDERWRITING")

    in cell A4 should do it.

    Cheers, Jason.

  4. #4
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: If 2 cells do not match produce a message

    thank you all, working perfectly

    ricky

+ 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