software

Hi,
I am new to excel.
I have the following data:
Zip Chapter
94789
50000

I need the chapter filled in based on the zip. i.e if zip lt; 10000, fill
in NY chapter, if between 90000 amp; 95000, fill in SF-bay etc.

Is there a way to define this without using vlookup i.e having the data
in same/another worksheet?

Thanks--
asra
------------------------------------------------------------------------
asra's Profile: www.excelforum.com/member.php...oamp;userid=31030
View this thread: www.excelforum.com/showthread...hreadid=507773Nope. If you have a long list of zips, the absolute best method is vlookup.
What do you have against it? Vlookup can use a named range as the area, and
you can put it on another worksheet, and even hide that sheet if you like.
See:
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;asraquot; gt; wrote in message
...
gt;
gt; Hi,
gt; I am new to excel.
gt; I have the following data:
gt; Zip Chapter
gt; 94789
gt; 50000
gt;
gt; I need the chapter filled in based on the zip. i.e if zip lt; 10000, fill
gt; in NY chapter, if between 90000 amp; 95000, fill in SF-bay etc.
gt;
gt; Is there a way to define this without using vlookup i.e having the data
gt; in same/another worksheet?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; asra
gt; ------------------------------------------------------------------------
gt; asra's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31030
gt; View this thread: www.excelforum.com/showthread...hreadid=507773
gt;