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
Bookmarks