Excel Formulas
 

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

Excel Formulas
 

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

Excel Formulas
 

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

Excel Formulas
 

Hi Valko,

this link looked great but did not give me the answer I was searching for.
Thankyou anyway. I am trying to create a recipe that utilises a price list as
a reference point. Any other ideas?

Blacksmith

"T. Valko" wrote:

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

Excel Formulas
 

Cheers Max

unfortunately I could not get this formula to work for me. What would be
ideal is a word based refernce system that identifies data from a
corresponding cell into a new cell. Ce La Vie

blacksmith

"Max" wrote:

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

Excel Formulas
 

Sounds like a simple VLOOKUP to me.

Create a table of words and values, and then use like so

=VLOOKUP(the_word,lookup_table,2,False)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Blacksmith" wrote in message
...
Cheers Max

unfortunately I could not get this formula to work for me. What would be
ideal is a word based refernce system that identifies data from a
corresponding cell into a new cell. Ce La Vie

blacksmith

"Max" wrote:

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