I have been working on a program that is comparing a model list of tickers to a large list of individual portfolio tickers. Using the Vlookup function I can easily see what are in the individual portfolio lists that isn't in the model but I am unsure of how to create an output that can tell me what isn't in the portfolio that is in the model restarting at each portfolio code. See below

Model Tickers/Portfolio Code /Portfolio tickers
CVX/j200/CVX
CMCSA/j200/CMCSA
------/t400/CVX
------/g300/TGT
I hope that makes sense.
In an ideal world, I would like the output either to insert a row with the missing ticker under the corresponding portfolio code or a column next to the code with all the tickers missing listed.
I am praying there is some way to do this without using the advance filter -unique records process, but any ideas are welcome.

Thanks!