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.

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

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

Originally Posted by Blake 7

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.

so, here is the file.

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.