Rialtus (rialtus) wrote,

Excel: Identify duplicate items on two columns

You have two columns of data. They can be on different sheets for all I care. You want to identify the duplicate information -- datum on one column that is also in the second column.

This example gives the assumption that column A has one column of data, and the other listing of data has the named area of "List". (To create named area, highlight info, Insert, Name, Define). Using column B, enter the following equation: =VLOOKUP(A1,list,1,FALSE)

If there is a match, you will see the matching information. If there is no match, you will see the "#N/A" error.
Tags: excel, reference
  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 1 comment