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?action=getinfo&userid=32343 View this thread: http://www.excelforum.com/showthread.php?threadid=521024

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

>

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?action=getinfo&userid=32343 View this thread: http://www.excelforum.com/showthread.php?threadid=521024