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

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

Hi Joe,

Here's an Index/Match formula. I use these rather than VLOOKUPs because
they're not as particular about your lookup lists.

Try this (assuming that your ranges are A2: E100, with A1:E1 containing the
headings, ie. "Part Numbers"). Put the formula below in cell B2 (again,
assuming the range of values is rows 2 through 100), and drag down to the end
of the range.

INDEX($A$2:$E$100,MATCH(D2,$A$2:$A$100,0),5)

Remeber to observe/include the absolute values ($ signs)

Exceller

"joecrabtree" wrote:

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