Hello All, I am trying to compare two spreadsheets to find which values on Spreadsheet A are missing fro Spreadsheet B.

Spreadsheet A–> 24k rows and my original dataset. 
Spreadsheet B–> 56k Rows

I have tried all sorts of formulas and nothing seems to be working out without needing to do 7 steps every time, I am hoping there is an easier way to make this happen. 

Both datasets have a Column Header “CD Number”. I have tried Vlookup around this but the result only returns data points that are missing a CD number, which is correct, BUT I know there are also CD numbers contained in A, that were NOT included in B, but when I do the VLOOKUP they do not show. Any suggestions for me would be great! Thank you!

​Hello All, I am trying to compare two spreadsheets to find which values on Spreadsheet A are missing fro Spreadsheet B.Spreadsheet A–> 24k rows and my original dataset. Spreadsheet B–> 56k RowsI have tried all sorts of formulas and nothing seems to be working out without needing to do 7 steps every time, I am hoping there is an easier way to make this happen. Both datasets have a Column Header “CD Number”. I have tried Vlookup around this but the result only returns data points that are missing a CD number, which is correct, BUT I know there are also CD numbers contained in A, that were NOT included in B, but when I do the VLOOKUP they do not show. Any suggestions for me would be great! Thank you!  Read More

​