Maybe you mean something like this ..

Assume you have in Sheet15,
box nos listed in E2 down, eg: Box1, Box2, etc
with corresponding quantities listed in B2 down, eg: 5, 7, ..

In Sheet1,
Assume the lookup values, eg: Box2, Box1, etc would be entered in A2 down

To retrieve the corresponding quantities from Sheet15
Put in C2:
=INDEX(Sheet15!B:B,MATCH(A2,Sheet15!E:E,0))
Copy C2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Blacksmith" wrote:
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