I am currently trying to make comparison between two excel files. I need to match the value of User ID (Excel 2) with User ID (Excel 1).
- If value match, I have to write “Open” on column Status (Excel 1).
- Then if we found a match from first condition, everything from the same group of that user ID also I have to write “Open”.
Example: I found a match for User ID = 18. User ID 18 is on Group A. So I have to write status “Open” to User ID = 1 & User ID = 23 since they are from Group A.
Result should be like this: