Excel Formulas

[Guest]

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

 

[T. Valko]

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

http://contextures.com/xlFunctions02.html

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

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)