Function to take current rates from a list to other cells.

Hello,

Please see attached excel doc


When a company is selected from dropdown lists in Column I, I need the company's corresponding WD Rate & WE Rate from columns C & D to populate columns X & Y.

These values should then be removed from X & Y if "" is selected in column I.


In future I will need to change the WD Rate & WE Rate in columns C & D of each company without this then changing the values previously added to X & Y.

The new rate from C & D should only update columns X & Y if column I is changed in the same row.



I'm looking for something similar to the function I currently have set up for changes to column N.


Thanks in advance for any help.