1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Resolved Excel 2003 Compare Macro/Formula

Discussion in 'Other PC Software' started by jsmith50, 2009/09/17.

  1. 2009/09/17
    jsmith50

    jsmith50 Inactive Thread Starter

    Joined:
    2002/05/23
    Messages:
    54
    Likes Received:
    0
    I have Office 2003 SP3 on XP PRO, SP3.

    The question I have is this for Excel 2003:

    I have data in two different Excel sheets. Data in column "A" in both sheets has the same 'type' of data. Sheet1, column "A ", has the user ID (8 characters). Sheet 2, column "A ", has the user ID (8 characters). I want to compare the data in sheet 1 - column "A" to the data in sheet2 - column "A" and place an "X" in sheet1 column "B" if the data matches Sheet 2 - column "A" . In other words if Column "A" data sheet1 matches column "A" sheet 2 data, place an "X" in Column "B" Sheet 1.

    Is there a VLOOKUP macro/formula to do this type of compare? :)

    Thank you,

    Jim
     
    jsmith50,
    #1
  2. 2009/09/20
    jsmith50

    jsmith50 Inactive Thread Starter

    Joined:
    2002/05/23
    Messages:
    54
    Likes Received:
    0
    Resolved by finding a "VLOOKUP" formula
     
    jsmith50,
    #2


  3. to hide this advert.

  4. 2009/09/20
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Thanks for the update .....

    I've marked this thread as 'Resolved', please see .....
     
    PeteC,
    #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...