Compare columns in 2 sheets and then return a value in another column

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.

Try this code:

Please Login or Register  to view this content.

Hi,

Thank you. I tried the code but I just get a msgbox that appears stating the number 4.

Not sure if you have mis-understood my requirement. Sorry if comes across as confusing.

I just need a formula that will check to see if the org codes match on both sheets and then populate the 'owner' column in the sheet NEW with whatever is populated in the owner column in sheet OLD. Thanks

Here is another attempt.

Please Login or Register  to view this content.