Lookup or similar

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.

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" <Andycleos@discussions.microsoft.com> wrote in message
news:39A1D2B2-B38B-4348-8785-A9A07393376D@microsoft.com...
> 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.

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
lookup.

"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.
>
> --
> HTH
>
> Bob Phillips
>
> "Andycleos" <Andycleos@discussions.microsoft.com> wrote in message
> news:39A1D2B2-B38B-4348-8785-A9A07393376D@microsoft.com...
> > 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.
>
>
>

=VLOOKUPA2,M1:R100, year+1,False)


--
HTH

Bob Phillips

"andycleos" <andycleos@discussions.microsoft.com> wrote in message
news:A5E70221-148C-4B53-A161-E336F425E1D2@microsoft.com...
> 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
> lookup.
>
> "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.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Andycleos" <Andycleos@discussions.microsoft.com> wrote in message
> > news:39A1D2B2-B38B-4348-8785-A9A07393376D@microsoft.com...
> > > 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.
> >
> >
> >

So what do i have to write in cell (XXXXX) under VALUE in order for it to
match whatever is writen under the cell TREE? Everytime cell TREE will
change. In this example the value will be 400. I forgot to mention that
Orange4 will come out of another formula.

Year1 Year2 Year3 Year4 Year5
Orange 100 200 300 400 500
Banana 300 400 500 600 700
Apple 500 600 700 800 900
TREE VALUE
Orange4 XXXXXXX

You've lost me.

--
HTH

Bob Phillips

"andycleos" <andycleos@discussions.microsoft.com> wrote in message
news:3BEFA76B-1DA9-4FA9-ACB2-77B66423556A@microsoft.com...
> So what do i have to write in cell (XXXXX) under VALUE in order for it to
> match whatever is writen under the cell TREE? Everytime cell TREE will
> change. In this example the value will be 400. I forgot to mention that
> Orange4 will come out of another formula.
>
> Year1 Year2 Year3 Year4 Year5
> Orange 100 200 300 400 500
> Banana 300 400 500 600 700
> Apple 500 600 700 800 900
> TREE VALUE
> Orange4 XXXXXXX
>