A question involving attaching formulas
 

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:confused:

can someone help me?:)


--
Dries
------------------------------------------------------------------------
Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
View this thread: http://www.excelforum.com/showthread...hreadid=521024

A question involving attaching formulas
 

Hello 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:

http://contextures.com/xlFunctions02.html

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

http://contextures.com/xlDataVal01.html

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

Judith

--
Hope this helps


"Dries" wrote:


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:confused:

can someone help me?:)


--
Dries
------------------------------------------------------------------------
Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
View this thread: http://www.excelforum.com/showthread...hreadid=521024