Lookup a value in list and return a value from the same list

Hi, i know that there are formulas for looking up values and returning corresponding items from an adjacent column, but is there a formula for returning values from the same list?

so in the following example

Apple
Crunchy
Red
Round
Pear
Green
Juicy
Oblong

I want to find the value 'Apple' and return crunchy, red and round (if there is a way that it could stop at pear that would be really really useful!)

Thanks for any help in advance