Maybe?? your part numbers should all be in the same column, but maybe not.
Look in the help index for VLOOKUP or use MATCH within and INDEX formula.

--
Don Guillett
SalesAid Software

"joecrabtree" wrote in message
oups.com...
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