Since you're using VLOOKUP, just post the minimum value for each item. Like
this:

100 Apple
151 Orange
201 Kiwi

Now, using VLOOKUP:

=VLOOKUP(167,A1:B3,2)

This returns "Orange"

VLOOKUP will match the largest value that is less than the lookup value.
So, for this example, 151 would be the largest value in the table that is
less than the lookup value (167). Note that this will return an error if the
lookup value is less than 100.

HTH,
Elkar

"bactfarmer" wrote:

This so a VLOOKUP can look at one cell instead of a list of cells.

On Jan 30, 1:09 pm, "bactfarmer" wrote:
Can asinglecellcontainmultiplepossibleentriesto cut down on the
size of a table.

I would prefer have this
100-150 Apple
151-200 Orange
201-250 Kiwi

I would not prefer to have this
100 Apple
101 Apple
102 Apple
etc
151 Orange
152 Orange
153 Orange
etc
201 Kiwi
202 Kiwi

Thanks
bactfarmer