Saturday, October 22, 2011

yogi_Replace Affected Cells In One Column With Contents In A Column Of Another Sheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user StaffBar said:
Hope someone can help with an ArrayFormula problem...
I have a sheet called Sales which lists Sales Person Names and Sales Value as columns Person, Sales
There are multiple rows with names and values in.
Some of the names are incorrect in this sheet. I have another sheet with corrections in it.
The correction sheet contains Person, Correction as columns.
Is it possible to use an array formula in a third sheet to create a new version of the Sales sheet with the names corrected in it?
I need to be able to do this dynamically as the source system for the sales sheet can't be changed and the list of changes also alters frequently...
---------------------------
Following is one solution to the problem