No Match formula that ignores when one cell is blank and other has data?

Just what the title says. I have a spreadsheet with duplicated columns (poor management by the person before me) but the data sometimes differs. I have a worksheet where I can paste both columns to c...