Question: vlookup has to be sorted?
Answer: Because the range_lookup value was omitted, VLOOKUP uses an approximate match, which requires the data to be sorted in ascending order. MATCH searches the SKU column for the value in cell F3 and returns the row-index number where the item is found.