I need help on an equation in the (Automated Data Correction) sheet that will copy over all the information from the (Raw Data Export) sheet, but will as well, based on the “Name” column (B), access specified changes that have been manually made to each cell contained in the (Manual Data Correction) sheet and based on those specific manual changes, the equations in the (Automated Data Correction) sheet will automatically make those same changes to correct all the data contained in the (Automated Data Correction) sheet.
Also note, one constant that must be used between all three sheets each “Name” has specific data contained in the rows of cells to the right of column B and is to be used as a specific data reference.
If there’s a way to combine a V-LookUp and an index/match it may work, but I’m not sure how exactly to write the equation to make it work.
Please see the attached example spreadsheet for clarification. Just to highlight, the cells in the “Raw Data Export” sheet that are red indicate the incorrect data and the cells in the “Automated Data Correction” sheet indicate the automatically corrected data. The colors are not to be used in the final product and are just here in the attachment to help clarify.
Thank you for your help and let me know if I can answer any further questions you may have.
Bookmarks