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
>
>
Bookmarks