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