To all,

I need help with the following.

I have a list of part numbers in column A. In column D I have a list
of part numbers. In column E I have a price for these part numbers.


Is there anyway that I can loop through column A so that it matches
the part number to that of column D, and then Assigns the price
( Column E) to column B automatically if it matchs,without having to
go through manually and allocating the price?


Please let me know if you need anymore info.

Thanks in advance for your help,

Regards

Joseph Crabtree