Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple entries per cell to save on table size?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple entries per cell to save on table size?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple entries per cell to save on table size?
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 "bactfarmer" wrote in message ups.com... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple entries per cell to save on table size?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Input Cell in One variable data table | Excel Worksheet Functions | |||
Multiple Employee Name Entries in One Cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |