Hi,
I have attached my excel spreadsheet which I have been trying to develop. The problem I have is as follows:
I have an old list or organizations. A system generates a new list of organizations however it does not produce the Owner column.
I have an old list of organizations which I need to compare monthly to a new list of organizations to highlight differences and identify the owner in the new list organizations.
Ignore the conditional formatting - I think I have found a formula to highlight the differences whereby a comparison is made and a value appears in the ACTION column.
I need a formula which:
1. Compares the org code in the new list to the org code in old list to check if they match.
2. if the org codes in both sheets match, the OWNER column in the NEW sheet should be populated with the value from the OWNER column in the OLD sheet.
3. if the org codes do not match no value should appear in the OWNER Column of the new sheet.
Any help would be appreciated.
Bookmarks