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