multiple entries per cell to save on table size?

[bactfarmer]

Can a single cell contain multiple possible entries to 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

 

[bactfarmer]

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

 

[T. Valko]

You can certainly do that.......however, what is this table used for? Will
you need to use formulas to extract data from this table? If so, what you
want to do will make things more difficult.

Biff

 

[Guest]

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