intersect between a double and a (complicated) cell array

I have a double array A

and I have a cell array B

I want to extract the values in array A, that also are contained in the sixth column of array B.

Ηow this can be achieved?

[Walter Roberson]

The 6th column contains cell entries, but you did not tell us anything about the structure of those cell entries.

What output structure do you need? Do you want to know the elements of A that appear anywhere in any entry in column 6? Do you want to know, for each row of B, which elements of A that appear anywhere in any entry in that row of column 6? Do you need a breakdown of locations per entry in A ?

[Ioannis Vourvachakis]

Yes you are right, the cell entries in the sixth column contain numbers (like the numbers in array A).

Yes, I just want to know the elements of A that appear anywhere in any entry in column 6.

[Stephen23]

Context: https://www.mathworks.com/matlabcentral/answers/1579979-input-a-of-class-cell-and-input-b-of-class-cell-must-be-cell-arrays-of-character-vectors-unless-one

Answer 1

[Walter Roberson]

col6_numerics = cell2mat(vertcat(YourCell{:,6}));
A_that_appear = A(ismember(A, col6_numerics));

[Ioannis Vourvachakis]

Thank you very much!!

[Ioannis Vourvachakis]

Hello! And if I want to know, the row of B, which elements of A appear in any cell entry in that row of column 6?