I am curious of performance from doing a loop vs a Match function. If I have a worksheet lets called parts with 10,000 rows and 15 columns. I have another worksheet in the same workbook lets call regional daily orders. If every day I review every row in the regional daily orders worksheet (daily row count of 500) for a column called part number and find the corresponding part number in the worksheet called parts and store the value price and manufacture is this better accomplished with a loop or match function or something else.
I am pretty familiar with loops, but I do not want this to be a case where I am doing a loop for comforts sake...if there is a better method then I would like to learn..