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

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

Hi Dries,

It looks like what you are after is using a lookup table - check the
helpsection for VLOOKUP

HTH

Ed


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

now I have all my formulas using vlookup, but now I have to use the
fomulas multiple times, how can I do it easily without having to copy
them like 100 times and then adapting it to the other cells?

eg. (this is an easy example)
A1__________B1______C1_______D1
corpus______560_____660______450

D1 is the result of a formula between B1 & C1. (B1 & C1 has to be found
in a tabel, but that's not the problem here)

then, when I have an other corpus, let's say:

A2__________B2______C2_______D2
corpus______500_____700______?

then I'll have to copy my fomula from the fist example and then change
the cells B1 & C1 to B2 & C2 in that formula, that's no prolem but I
have like 100 different corpusses then I'm going to have a lot of
adapting to do. Can this be done more easily? with a macro or
something, or (but I'm a noob in that) with Visual Basic?


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