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