Compare tables and mark differences (vlookup?

[goodhope]

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.

Here is the sheet: https://spreadsheets.google.com/ccc...UVUVneWUxNVBXUHc&hl=en&authkey=CK-05ukN#gid=0<!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[mancemonster]

Hi Welcome to the boards!

If you want to use Vlookup, to compaire the tables, firstly you will need a list of all Appl Shortnames.

I've coppied the data you loaded into a work book.

Column S I have created a list of unique Appl Shortnames.

in cells..
T2 put A
U2 put B
V2 put C
W2 put D
X2 put E
Y2 put F

T3 =VLOOKUP(S3,$A$3:$B$59,2,0)
And drag the formula down

U3 =VLOOKUP(S3,$D$3:$E$59,2,0)
And drag the formula down

V3 =VLOOKUP(S3,$G$3:$H$59,2,0)
And drag the formula down

W3 =VLOOKUP(S3,$J$3:$K$59,2,0)
And drag the formula down

X3 =VLOOKUP(S3,$M$3:$N$59,2,0)
And drag the formula down

Y3 =VLOOKUP(S3,$P$3:$Q$59,2,0)
And drag the formula down


#N/A Returns where no App matches.

Regards

 

[mancemonster]

Oh and payment is not required... If you feal the need put the $10 to charity.

Hope the solution works for you!

Regards