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.