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