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