IF same CONTENT FOUND IN CELL A THEN DELETE CONTENT IN B,C or D

I need following the following accomplished. I will also need the ENTIRE ROW deleted if Column B had content deleted by this action.

Thanks!IF-FOUND-DELETE.xlsx