well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul
remove nospam for email addy!



"CroatWonder" wrote:


Hi guys,

Thanks for answering so quickly.


Paul, you hit the nail on the head, the formulae do vary with
temperature!

This is where my problem lies, that each component has a material,
which has a corresponding general formula. But each component also has
a temperature that I need to use in the general formula.

So I need to apply a statement in each component specifying which
general formula to use and which temperature. I just don't know how to
do this, any ideas?


Gary's Student, I have looked at the Concatinate function but I don't
see how I can utilise it in this problem. Could you give me an
example?

Thanks again,


CroatWonder



paul Wrote:
if you have the vlookup table for the material and its associated
formula you
could then have a separate cell for your temperature
=vlookup(material,material table,2,false)*A1 where A! is your
temperature
and column 2 is your formulas....dont tell me that the formulas vary
with
temperature too!
--
paul
remove nospam for email addy!



"CroatWonder" wrote:


Hi,

I have been struggling with the same problem since last week and
really
hope that someone can help me.


My worksheet has three columns, the first is a material input, the
second the temperature (T) input and the third is an equation (say y
=
mT +c). There are also 20 rows for different components.


Each material has a different formula which is defined on a separate
sheet. My problem is with using both the temperature and Material as
inputs. I can reference the equations for each material but I can't
get
them for the different temperatures.


I'm not sure whether (and how) to nest VLOOKUP functions or if there
is
a simplier solution.

I hope that my explanation is clear and that some Guru may be able
to
help me! Thanks,


CroatWonder


--
CroatWonder

------------------------------------------------------------------------
CroatWonder's Profile:
http://www.excelforum.com/member.php...o&userid=25804
View this thread:
http://www.excelforum.com/showthread...hreadid=392069




--
CroatWonder
------------------------------------------------------------------------
CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
View this thread: http://www.excelforum.com/showthread...hreadid=392069