Extract columns which are not in the same order as Reference file

[Anonymous]

My reference excel is 

Col 1|Col 2|Col3

My other file is

Col3|Col2|Col1

I need to extract Col1 and Col3 which are not in the right order as the output.