Hi,

I have spent the best of today trying to figure out how to create a formula
for an Excel workbook that will enter a figure from a list in "work sheet 15"
every time that word is used in other sheets. In other words I need Excel to
recognise "Boxes" in column A of worksheet 1 and enter the figure for "Boxes"
(found in worksheet 15) into column C of worksheet 1. I need this to enable
the updating of prices in one worksheet to automatically update all the
others. What a mouthful. I know the slow way... press = and click on the
corresponding cell but this will take forever and a day.

cheers