Thanks for the reply but i have one more question,
I need a cell that will combine the two functions. That means that i need a
cell that will give me lets say number 200 everytime that i have in another
cell "Orange2". My problem is that i have too much data for one formula of
"Bob Phillips" wrote:
> 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.
> Bob Phillips
> "Andycleos" <Andycleos@discussions.microsoft.com> wrote in message
> > I have some trees and i want to get some prices for them in different
> > 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.