software

hello

(I'm from belgium so my english therms might not be thát good)

don't know where to start but I'll try, my problem is:

They asked me to 'attach' formulas to words
example; if I typ 'Corpus' (or select it in some sort of a pop up menu)
the formulas (attached to it?) have to appear automaticly some cells
further.

actually it's for calculating prices, so if I want to calculate a
certain closet, I have to choose the different parts (like corpus or
door) with the different formulas attached (because there are different
doors).

it's kinda hard to explain I know

can someone help me?--
Dries
------------------------------------------------------------------------
Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
View this thread: www.excelforum.com/showthread...hreadid=521024Hello Dries,

Your English is alot better than my Belgium so I wouldn't worry!

It sounds like you want to use the VLOOKUP function. That will enable you to
type in the name of the part and have the cost information appear else where.
Check out this link for a great tutorial:

contextures.com/xlFunctions02.html

If you want a pop-up menu you will need Data Validation.
Check out this link:

contextures.com/xlDataVal01.html

Post back with any questions, I'll keep an eye out!

Judith

--
Hope this helpsquot;Driesquot; wrote:

gt;
gt; hello
gt;
gt; (I'm from belgium so my english therms might not be thát good)
gt;
gt; don't know where to start but I'll try, my problem is:
gt;
gt; They asked me to 'attach' formulas to words
gt; example; if I typ 'Corpus' (or select it in some sort of a pop up menu)
gt; the formulas (attached to it?) have to appear automaticly some cells
gt; further.
gt;
gt; actually it's for calculating prices, so if I want to calculate a
gt; certain closet, I have to choose the different parts (like corpus or
gt; door) with the different formulas attached (because there are different
gt; doors).
gt;
gt; it's kinda hard to explain I know
gt;
gt; can someone help me?
gt;
gt;
gt; --
gt; Dries
gt; ------------------------------------------------------------------------
gt; Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
gt; View this thread: www.excelforum.com/showthread...hreadid=521024
gt;
gt;