+ Reply to Thread
Results 1 to 7 of 7

Compare tables and mark differences (vlookup?)

  1. #1
    Registered User
    Join Date
    03-24-2011
    Location
    berlin
    MS-Off Ver
    Excel 2003
    Posts
    3

    Compare tables and mark differences (vlookup?)

    hi all

    i need to compare some tables and someone told me to use vlookup, but he couldn£t explain it to me. so it would be cool if someone here could help me. i can not spend a lot of money on this,

    and i guess it is just a matter of seconds for an excel specialist. but i could pay usd 10, so at least it is a a visit to the cinema or so :-).

    so once again, i have 5 tables (one per person) in an email which i copied into an excel
    sheet. each table has 2 columns. in this tables are applications and prio, these are different, so the goal is, that every person has the same application and prio and that the
    changes are somehow marked, so that i can see who needs the application and which prio
    which prio has to be changed.

    i hope i explained it correct in englisch and i hope someone can help me.

  2. #2
    Registered User
    Join Date
    03-17-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Compare tables and mark differences (vlookup?)

    give this tutorial a glance and let us know if you have some questions from there!

    http://www.tutorialized.com/view/tut...-Vlookup/66323

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,373

    Re: Compare tables and mark differences (vlookup?)

    I would love to help a European cousin! especially someone from a country that produces such great beer and schnitzel. From your explanation it would be very difficult to help, i would suggest uploading your excel workbook and describe there how you want it to look. What is Prio by the way?
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  4. #4
    Registered User
    Join Date
    03-24-2011
    Location
    berlin
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Compare tables and mark differences (vlookup?)

    Quote Originally Posted by Blake 7 View Post
    I would love to help a European cousin! especially someone from a country that produces such great beer and schnitzel. From your explanation it would be very difficult to help, i would suggest uploading your excel workbook and describe there how you want it to look. What is Prio by the way?
    hi black
    i am sitting in a bar smoking a cigar and drinking a koestritzer black beer while i read tour answer .
    prio is just a short form of priorisation. the users have different rights for the applications from the first colum. These need to be also marked. i can not upload from this device, so i will do this in an hour. thanks in advance.

  5. #5
    Registered User
    Join Date
    03-24-2011
    Location
    berlin
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Compare tables and mark differences (vlookup?)

    so, here is the file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-25-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Compare tables and mark differences (vlookup?)

    Hi goodhope,

    Just in case it's helpful, Workshare has a tool that highlights changes in Excel. It's called Compare for Excel and there's a free trial here: http://www.workshare.com/products/compare-excel/

    This may work since you are considering changing columns within the tables and you want the changes marked.

  7. #7
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,373

    Re: Compare tables and mark differences (vlookup?)

    Hi GH - i am afraid that you will have to make more of an effort than that! There was no description of your desired output in the attachment as requested.

+ 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