Forum Discussion

Copper Contributor

Aug 06, 2020

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...

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

Charla74

Iron Contributor

Aug 06, 2020

leanneo81

You should be able to do this with the VLOOKUP formula with the lookup based on the SKU.

=VLOOKUP(Your Sheet SKU, Supplier Sheet Range Starting With SKU Col, Relative Col Number in Range Containing Price)