Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!lll-winken!miguel.llnl.gov!macq
From: macq@miguel.llnl.gov (Don MacQueen)
Newsgroups: comp.sys.mac.apps
Subject: Re: MS Excel question: LOOKUP
Message-ID: <97262@lll-winken.LLNL.GOV>
Date: 14 May 91 22:55:19 GMT
References: <11214@hub.ucsb.edu>
Sender: usenet@lll-winken.LLNL.GOV
Distribution: comp.sys.mac.apps
Organization: Lawrence Livermore National Laboratory
Lines: 34
Nntp-Posting-Host: miguel.llnl.gov

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
--------------------