+ Reply to Thread
Results 1 to 3 of 3

Comparing data in 2 sheets

  1. #1
    Forum Contributor
    Join Date
    06-20-2012
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    379

    Comparing data in 2 sheets

    Hi,

    On the attached I am looking at comparing data cell for cell on sheet 'Comparison' against sheet 'Personna Doc'.

    I was experimenting with a MATCH formula.

    Can anyone suggest an alternative/better formula?
    Attached Files Attached Files

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Comparing data in 2 sheets

    Hi JakeMann

    How about:
    =IF(A2='Personna Doc'!A2,"Match","Doesn't match")
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  3. #3
    Forum Contributor
    Join Date
    06-20-2012
    Location
    Derby
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Comparing data in 2 sheets

    Thanks Kevin, just the job

+ 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