Find and Match Between Two Lists, Delete Matched Ones and List Again

[zakmuh]

Hi,
Please see attached screenshot below.....In Googlesheet, Ive done it to find matching VERO titles and lists it in column E. I now want it to get those from the columns A and B, delete matching vero titles + SKUs and then put the rest in column G and H as shown. Would this be possible with a formula?

Formula currently used:
D5 =ARRAYFORMULA(IFERROR(LOOKUP(2,1/SEARCH(" "&C5&" "," "&$B$5:$B$11&" "),$B$5:$B$11),""))
E5 =IFERROR(filter(D5:D11,D5:D11<>""))

Thank you very much in advance

 

[zakmuh]

Found the solution:

F5 =IF(COUNTIF(D6:D12,B6)=0,A6,"") G5 =IF(COUNTIF(D6:D12,B6)=0,B6,"")

I5 =IFERROR(filter(F5:F11,F5:F11<>"")) J5 =IFERROR(filter(G5:G11,G5:G11<>""))

Cheers