How to get result for duplicate value with lookup ?

From your question it is not very clear that whether you want to find out the duplicates or similar but having different corresponding row cell values against them.

Anyway, for identifying duplicate values you have to select all the values in the columns for which you want to find out duplicates. After this select conditional formatting in excel home and go to cells rules and choose duplicate values. This selection will catch all the duplicates in the selected range.

Now you can remove them or temporarily move to another column till you handle the remaining data in the original column.

If you want to go further for logical removal of data for a particular condition you will have to choose if (condition) then (do this) by selecting the range on which you want to do this logical separation.