Dear Community
I am struggling and would appreciate some advice please. It is probably a combination of IFs & Index/Match
I have two tabs of data about 44,000 rows.
In Initiatives 1, I currently have Outturn (£) run rate data
In Initiatives 2, I have Weighted Pipeline (£) data
I need to update initiative 1 Outturn (£) run rate column AN, with the value of Weighted Pipeline (£) - initiative 2 - column AN i.e. Replace
It will look at the ID column E in both tabs and if initiative 2 has value in column AN it will replace that value in initiative 1 - column AN
If there is no value is initiative 2, it will not replace but use the value that already exists in initiative 1
Bookmarks