Extract data from other Excel worksheets using VLOOKUP

My landlords approached me and asked if I knew anything about Excel. My initial thoughts were “I know how to add and subtract with =SUM() and that’s about it”. But I thought, how hard can it be? They tasked me to sort their product list into one file so all their products had the appropriate product codes, UPC codes, descriptions, cost & sell price and physical attributes (length/width/height/weight). The idea was to then import the …

Read more