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