azcalv
07-22-2006, 10:35 AM
Hi,
I have one column on my sheet with a long list of part numbers (PartNum). I populated into a 2-dimen array that contains the part numbers and another set of values (Cost). Is there a way to paste into a 2nd col. the Cost only if the part numbers in the array match up with the ones in the sheet? I don't want to use a loop to match each one by one since it takes too much time :think: Please help :bow:
I have one column on my sheet with a long list of part numbers (PartNum). I populated into a 2-dimen array that contains the part numbers and another set of values (Cost). Is there a way to paste into a 2nd col. the Cost only if the part numbers in the array match up with the ones in the sheet? I don't want to use a loop to match each one by one since it takes too much time :think: Please help :bow: