I have a file that is sorted by Column D which I am calling "Old_Id". Column B which is called "Match Found" has a value of "Y" set by another program.
Is there a way to update Column A "ID Match" with a "Y" if there is a "Y" in column "B" in any row where Column "D" is the same.
(See attached file). The results I would like a formula for are in Red Font.