Formulas for matched and unmatched data for 2 lists

[alcorp]

Hi,
I am not trying to compare the right to the left, I am trying to compare two lists completely and find whats missing going left to right and right to left and produce a new list of data that is not matched.

I tried using this formula but I am only getting a false value. I also want to know if this the right one to use and what is the correct way to have this formula.
=IF(ISNA(VLOOKUP(B:B,$B$2:$B$778113,1,FALSE)),A2)

I want to display the data that doesn't match in either list.


I also am using this formula to match the two lists and find what's the same with this formula and I want to know if this is correct too. It seems like it's fine but I am double checking.
=IF(ISERROR(MATCH(A2,$B$2:$B$778113,0)),"",A2)

This formula displays the matched info from both lists. (Not left to right but going both ways)

Anything helps, Thanks!

 

[AhoyNC]

See if the attached link helps.
Also, if you go to his YouTube channel "Excel is Fun" he has a number of videos on matching lists.

https://www.youtube.com/watch?v=0Ns2_2v7E0c