I am trying to write a fairly simple formula but I do not know how to complete it. I believe I need to use Index and Match but am stumped.
I have attached a sample sheet with the formula requirement written in plain English.
Essentially, it is checking that where a duplicate value exists in column B, check the values for both duplicates in column D and then return a result. However for usability I have set up the worksheet a bit differently with an additional column that identifies duplicates that preferably needs to be taken into account - as this is part of a larger file and process.
Bookmarks