# Nesting VLOOKUP functions

1. ## Nesting VLOOKUP functions

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

2. ## RE: Nesting VLOOKUP functions

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

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

3. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

4. Hi guys,

Paul, you hit the nail on the head, the formulae do vary with temperature!

This is where my problem lies, that each component has a material, which has a corresponding general formula. But each component also has a temperature that I need to use in the general formula.

So I need to apply a statement in each component specifying which general formula to use and which temperature. I just don't know how to do this, any ideas?

Gary's Student, I have looked at the Concatinate function but I don't see how I can utilise it in this problem. Could you give me an example?

Thanks again,

CroatWonder

Originally Posted by paul
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

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

5. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

6. ## RE: Nesting VLOOKUP functions

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

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

7. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

8. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

9. ## RE: Nesting VLOOKUP functions

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

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

10. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

11. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

12. ## RE: Nesting VLOOKUP functions

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

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

13. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

14. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

15. ## RE: Nesting VLOOKUP functions

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

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

16. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

17. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

18. ## RE: Nesting VLOOKUP functions

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

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

19. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

20. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

21. ## RE: Nesting VLOOKUP functions

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

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

22. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

23. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

24. ## RE: Nesting VLOOKUP functions

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

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

25. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

26. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

27. ## RE: Nesting VLOOKUP functions

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

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

28. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

29. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

30. ## RE: Nesting VLOOKUP functions

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

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

31. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

32. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

33. ## RE: Nesting VLOOKUP functions

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

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

34. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

35. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

36. ## RE: Nesting VLOOKUP functions

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

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

37. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

38. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

39. ## RE: Nesting VLOOKUP functions

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

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

40. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

41. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

42. ## RE: Nesting VLOOKUP functions

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

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

43. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

44. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

45. ## RE: Nesting VLOOKUP functions

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

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

46. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

47. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

48. ## RE: Nesting VLOOKUP functions

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

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

49. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

50. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

51. ## RE: Nesting VLOOKUP functions

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

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

52. ## RE: Nesting VLOOKUP functions

One solution is to CONCATINATE the various inputs to form a unique identifier
that VLOOKUP can find. For example, say you want to lookup the price of
tools: hammer, screwdriver, and drill. For each tool there is a price for
new and a price for used. instead of trying to VLOOKUP {drill new} create
drillnew by concatination.
--
Gary's Student

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

53. ## Re: Nesting VLOOKUP functions

well i think what you need to do is have two tables.and in the formula column
of your main table you have a vlookup formula for you temperature variable
formula .This means of course that one of your lookup variables has to be
temperature.So to lookup one of your materials you need to have an entry or
choice of temperatures otherwise you cannot chhose the correct formula
--
paul

"CroatWonder" wrote:

>
> Hi guys,
>
> Thanks for answering so quickly.
>
>
> Paul, you hit the nail on the head, the formulae do vary with
> temperature!
>
> This is where my problem lies, that each component has a material,
> which has a corresponding general formula. But each component also has
> a temperature that I need to use in the general formula.
>
> So I need to apply a statement in each component specifying which
> general formula to use and which temperature. I just don't know how to
> do this, any ideas?
>
>
> Gary's Student, I have looked at the Concatinate function but I don't
> see how I can utilise it in this problem. Could you give me an
> example?
>
> Thanks again,
>
>
> CroatWonder
>
>
>
> paul Wrote:
> > 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:

> > >
> > >

>
>
> --
> CroatWonder
> ------------------------------------------------------------------------
> CroatWonder's Profile: http://www.excelforum.com/member.php...o&userid=25804
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1