Please see the attached sheet. I want to check to see that the values in column B appear in column C. If so and there is a match, then the values in columns A and E should also match.
For example, B2 and B3 are duplicates with the following corresponding column A values:
FRG.EXT.ACT.0010
FRG.EXT.ACT.0020
When I do a control find for the B2 value in column C, I find that they do appear in column C in cells C1655 and C166. The corresponding value in column D also match with what was in column A.
Is there an automated way of doing this? Currently I’m performing a control find for each unique value, but I’m sure there’s a much more efficient way of doing this.
Thank you in advance
Bookmarks