Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell References [email protected] Excel Discussion (Misc queries) 2 November 16th 06 12:37 AM
Input cell reference is not valid (One Variable Data Table) Dottore Excel Worksheet Functions 9 September 1st 05 03:05 PM
Input Cell in One variable data table Dottore Magistrale Excel Worksheet Functions 0 August 30th 05 06:25 PM
Multiple Employee Name Entries in One Cell Dave Excel Discussion (Misc queries) 1 June 17th 05 03:33 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"