On the worksheet there are N numbers of column. On the 2nd column there
should be a drop down list of lets say N number of materials.And if any of
those material is selected on the 6th column the price of that corresponding
material must show automatically.Is this possible with excel 2002?How do I
make a list and synchronize it with the price?Please help.Thanks in advance.

Hi,

You need to use a VLOOKUP table - check out the help section to see how
to do this - it should be straight forward.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=529935