remove rows in cell if a column is equal to a number

So this is a simplified version of what I have, I want to remove the rows in X that match the number in the cell Y, so all I would have left is the first row. My real data has over a million rows, is there a quick way to do this? Thanks for your help!

X =

    'B737'    'DAL1240'    [10]
    'MD88'    'DAL1542'    [ 9]
    'B747'    'DAL1284'    [ 9]
    'B737'    'DAL1532'    [ 4]
    'A320'    'DAL1417'    [ 4]

Y =

    [9]
    [4]

Answer 1

[C.J. Harris]

X = {'B737'    'DAL1240'    [10]
    'MD88'    'DAL1542'    [ 9]
    'B747'    'DAL1284'    [ 9]
    'B737'    'DAL1532'    [ 4]
    'A320'    'DAL1417'    [ 4]};

Y = {[9]
    [4]};

X(ismember(cell2mat(X(:,3)),cell2mat(Y)), :) = [];

[Tiffany Lee]

thanks for the quick response! works great!

[Azzi Abdelmalek]

Tiffany you have to accept one of the answers that answers your question by clicking on accept this answer