Hi Guys

Is there anyway to confine a lookup search to a specific section of my data. i.e.

apple 0 a
apple 10 b
apple 20 c
apple 30 d
banana 0 e
banana 10 f
banana 20 g
banana 30 h
pear 0 i
pear 10 j
pear 20 k
pear 30 l

I have a much larger string of data, but for simplicity lets say I want to do a lookup on only the data with apple in the first column. OBviously this can be done with the vlookup but I need to use a lookup as the values in the second column are all upper bounds. I want to use the fruit and then the price in to find the upper bound in the second column and therefore the corresponding letter

Any help appreciated.

Thanks