🚀 go-pugleaf

In article <11214@hub.ucsb.edu>, 6600star@ucsbuxa.ucsb.edu (Lightning Man) writes:
|> I've got a question about the LOOKUP function in Excel 3.0. Is there
|> a way to get Excel to look at a single cell defining a _range_ of
|> integers? For instance:
|> This is the number I want to look up on the table: 6
|> Here's the table:
|> 1-2	this
|> 3-4	that
|> 5-8	Spam
|> 9-10	Macintosh
|> 
|> Is there a quick and dirty way to do this without using an ugly,
|> convoluted "IF" statement with lots of < and > characters?
|> 
|> This is a problem because I need to make some BIG tables, and having
|> each integer as its own entry would be REALLY time-consuming, as well
|> as making a BIG file...
|> 
|> Thanx in advance!
|> 
|> Matt Staroscik
|> 6600star@ucsbuxa.ucsb.edu

I don't use excel, so I can't be sure, but I thought that the lookup function found the row with the next largest number. If so, then this should work:

2  this
4  that
8  Spam
10 Macintosh
-- 
--------------------
Don MacQueen
macq@miguel.llnl.gov
--------------------