Cross reference from 2 excel files in Matlab

Hello,

I have two excel documents which I have imported to matlab with xlsread.

Now my task is to take a destination code from file 1 and match it with a destination name from file 2. (screenshots of the two different files)

I hope someone is able to help me with some pointers on how to do this.

Thank you in advance - Emil

Answer 1

[Nikhil Sreekumar]

Hi there,

What exactly is it that you are meaning on saying match the two columns?

• Comparing each row element in one with each row element in another?
• Comparing corresponding row elements?
• Comparing columns of different size?

If you doing xlsread and taking the raw data, then you can do something like this to do a corresponding element-wise comparison:

Case - Check if both columns same
[~, ~, raw1] = xlsread('data1.xlsx');
Destination1 = {raw1{:, 1}}; % column 1
[~, ~, raw2] = xlsread('data2.xlsx');
Destination2 = {raw2{:, 1}}; % column 1
isequal(Destination1, Destination2);

You can also check ismember function

• ismember

Thanks

Nikhil