Sounds like you want some sort of lookup formula. See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Blacksmith" wrote in message
...
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