Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Problems showing Matches between Column A and B in C

  • 27-01-2012 02:44PM
    #1
    WIZE
    Closed Accounts Posts: 3,597 ✭✭✭


    Hi All

    I need help with a Report in Excel

    Column A
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    Column B

    2
    4
    6
    8
    10

    I need in Column C to Show the Matches of column B in Column A

    Does anyone know how to do this

    Column C an have true or false or 1 or 0


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,165 ✭✭✭homer911


    To clarify, are you trying to put a 1 in column C opposite the entry in column a, where the value in column a is found in any position in column b?

    if so, a vlookup would be the best basis...


Advertisement