Article View: comp.sys.mac.apps
Article #9060MS Excel question: LOOKUP
From: Lightning Man
Date: Mon, 13 May 1991 19:20
Date: Mon, 13 May 1991 19:20
21 lines
1026 bytes
1026 bytes
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
Technical Details
Message-ID:
<11214@hub.ucsb.edu>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!pacbell.com!ucsd!hub.ucsb.edu!ucsbuxa!6600starShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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