Forum Discussion
Data search, match and replace
Hi, Not sure how best to explain this but I've recently implemented a new POS system in my retail shop which uploads product data in an excel spreadsheet with name, description, pricing, etc. I've ju...
VLOOKUP() or INDEX/MATCH or like will work, but you'll have both old and new price if only partial substitution is needed.
Better with Power Query both files and generate third clean one.
If you provide sample files with only few records in each it will be easier to demonstrate on formulas.