Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!ccu.umanitoba.ca!guelzow From: guelzow@ccu.umanitoba.ca (Andreas J. Guelzow) Newsgroups: comp.sys.mac.apps Subject: Re: MS Excel question: LOOKUP Message-ID: <1991May14.145937.21906@ccu.umanitoba.ca> Date: 14 May 91 14:59:37 GMT References: <11214@hub.ucsb.edu> Distribution: comp.sys.mac.apps Organization: University of Manitoba, Winnipeg, Canada Lines: 27 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? > I don't have Excel 3.0 yet but in the earlier versions you could simply use the LOOKUP function and change your table to: 1 this 3 that 5 Spam 9 Macintosh Andreas -- Andreas J. Guelzow