MACRO ?
 

Being new to the more technical aspects of Excel can anyone point me in the
right direction.
I want to compile a tree volume calculation table.
Example
A1 is diameter
B1 Is Height
C1 Number of trees
D1 Taper Value (which differs according to diameter)
E1 Tree Volume
What i want to do is by selecting a diameter it will automatically select a
taper figure.
I have all the input calculations just need some guidance knowing that it
probably too involved for a complete forum answer;
Thanks

MACRO ?
 

You need a table of two columns and a vlookup formula.

The left column of the table is the diameter (sorted in ascending order)
second column is the corresponding taper value
Say you are going to enter them in sheet2 A1 to B20
The vlookup formula will be in cell D1
=vlookup(A1,sheet2!$A$1:$B$20,2,false)

where A1 is the diameter and 2 indicates to look up the value in the second
column of the table.

you can extend this down the D column as far as you need to.

entering the table in sheet2 avoids any problems of having to add or delete
rows in sheet1


By the way is there any correlation between the diameter and the taper that
could be translated in a formula?


--
Greetings from New Zealand
Bill K

"lochrist" wrote in message
...
Being new to the more technical aspects of Excel can anyone point me in
the
right direction.
I want to compile a tree volume calculation table.
Example
A1 is diameter
B1 Is Height
C1 Number of trees
D1 Taper Value (which differs according to diameter)
E1 Tree Volume
What i want to do is by selecting a diameter it will automatically select
a
taper figure.
I have all the input calculations just need some guidance knowing that it
probably too involved for a complete forum answer;
Thanks

MACRO ?
 

Thanks Bill for your reply, i will play around with this and see what happens.
Yes there is a formula concerning the taper tarif we use.Can i send it to
you in an email with a worksheet example?

Many thanks
Pete

"Bill Kuunders" wrote:

You need a table of two columns and a vlookup formula.

The left column of the table is the diameter (sorted in ascending order)
second column is the corresponding taper value
Say you are going to enter them in sheet2 A1 to B20
The vlookup formula will be in cell D1
=vlookup(A1,sheet2!$A$1:$B$20,2,false)

where A1 is the diameter and 2 indicates to look up the value in the second
column of the table.

you can extend this down the D column as far as you need to.

entering the table in sheet2 avoids any problems of having to add or delete
rows in sheet1


By the way is there any correlation between the diameter and the taper that
could be translated in a formula?


--
Greetings from New Zealand
Bill K

"lochrist" wrote in message
...
Being new to the more technical aspects of Excel can anyone point me in
the
right direction.
I want to compile a tree volume calculation table.
Example
A1 is diameter
B1 Is Height
C1 Number of trees
D1 Taper Value (which differs according to diameter)
E1 Tree Volume
What i want to do is by selecting a diameter it will automatically select
a
taper figure.
I have all the input calculations just need some guidance knowing that it
probably too involved for a complete forum answer;
Thanks

MACRO ?
 

Sure,
Should be possible to put it all into one formula.
Bill K

"lochrist" wrote in message
...
Thanks Bill for your reply, i will play around with this and see what
happens.
Yes there is a formula concerning the taper tarif we use.Can i send it to
you in an email with a worksheet example?

Many thanks
Pete

"Bill Kuunders" wrote:

You need a table of two columns and a vlookup formula.

The left column of the table is the diameter (sorted in ascending order)
second column is the corresponding taper value
Say you are going to enter them in sheet2 A1 to B20
The vlookup formula will be in cell D1
=vlookup(A1,sheet2!$A$1:$B$20,2,false)

where A1 is the diameter and 2 indicates to look up the value in the
second
column of the table.

you can extend this down the D column as far as you need to.

entering the table in sheet2 avoids any problems of having to add or
delete
rows in sheet1


By the way is there any correlation between the diameter and the taper
that
could be translated in a formula?


--
Greetings from New Zealand
Bill K

"lochrist" wrote in message
...
Being new to the more technical aspects of Excel can anyone point me in
the
right direction.
I want to compile a tree volume calculation table.
Example
A1 is diameter
B1 Is Height
C1 Number of trees
D1 Taper Value (which differs according to diameter)
E1 Tree Volume
What i want to do is by selecting a diameter it will automatically
select
a
taper figure.
I have all the input calculations just need some guidance knowing that
it
probably too involved for a complete forum answer;
Thanks

MACRO ?
 

Hi Bill, only just seen your reply. Can you provide e mail so that i can
send example work sheet +formulas.
Thanks
Pete

"Bill Kuunders" wrote:

Sure,
Should be possible to put it all into one formula.
Bill K

"lochrist" wrote in message
...
Thanks Bill for your reply, i will play around with this and see what
happens.
Yes there is a formula concerning the taper tarif we use.Can i send it to
you in an email with a worksheet example?

Many thanks
Pete

"Bill Kuunders" wrote:

You need a table of two columns and a vlookup formula.

The left column of the table is the diameter (sorted in ascending order)
second column is the corresponding taper value
Say you are going to enter them in sheet2 A1 to B20
The vlookup formula will be in cell D1
=vlookup(A1,sheet2!$A$1:$B$20,2,false)

where A1 is the diameter and 2 indicates to look up the value in the
second
column of the table.

you can extend this down the D column as far as you need to.

entering the table in sheet2 avoids any problems of having to add or
delete
rows in sheet1


By the way is there any correlation between the diameter and the taper
that
could be translated in a formula?


--
Greetings from New Zealand
Bill K

"lochrist" wrote in message
...
Being new to the more technical aspects of Excel can anyone point me in
the
right direction.
I want to compile a tree volume calculation table.
Example
A1 is diameter
B1 Is Height
C1 Number of trees
D1 Taper Value (which differs according to diameter)
E1 Tree Volume
What i want to do is by selecting a diameter it will automatically
select
a
taper figure.
I have all the input calculations just need some guidance knowing that
it
probably too involved for a complete forum answer;
Thanks