Create a table in say M1:R100 to look like
Tree Year1 Year2 Year3 Year4 Year5
Orange 100 200 300 400 500
Banana 300 400 450 500 700
or whatvere values, and then just use
=VLOOKUP("Orange",M1:R100, year+1,False)
year+1 is 2 for one year old tress etc.
--
HTH
Bob Phillips
"Andycleos" wrote in message
...
I have some trees and i want to get some prices for them in different
years.
How can i do it?
For example: Orange trees (OT) and bananas (BA) that are 1,2,3,4,5 years
old. The prices for every type of tree is different. OT-1year - $100,
OT-2Years - $200 and BA-1year - $300, BA-2years - $400.etc.
How can i make a commant that will recognize the type of tree, its age and
give me the price that i want.
Please i really need it.
|