I need a formula to put in col J that looks for any value of text in row 1 sheet 1 to row 1 sheet 2 and if present leave blank but if not present put the value from col A row 1 and so on for each row in sheet 1. Can anyone help? See workbook attached.
Thank you,
Tami
Bookmarks