You could delete the empty lines using Autofilter. Filter one of the columns on blank, select the visible rows and delete them.
With regard to matching them, you could use VLOOKUP if you want to return information or just use COUNTIF if you only need to know if there is a match
Regards, TMS
Bookmarks