Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!pacbell.com!ucsd!hub.ucsb.edu!ucsbuxa!6600star
From: 6600star@ucsbuxa.ucsb.edu (Lightning Man)
Newsgroups: comp.sys.mac.apps
Subject: MS Excel question: LOOKUP
Message-ID: <11214@hub.ucsb.edu>
Date: 13 May 91 19:20:12 GMT
Sender: news@hub.ucsb.edu
Distribution: comp.sys.mac.apps
Lines: 21

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