software

I have a database with over 1,000 rows and 13 columns. One of the column
headings has a listing of about 23 different services. They want to add a
column basically assigning a number to each service....I know I can use the
IF function but apparently only for up to 8 arguments. Does anyone know if
there's a way to add more?? Is there a better formula for this?? Or can I
maybe lump three services???

A quick example of what I'm talking about

Services
NEB
CTH
IV
IV ABT
NEB

Say that's the list. I want to assign NEB's as a 1, IV and IV ABT as a 4.
I know I can use =IF(CELL=quot;NEBquot;,1,(IF(CELL=quot;IVquot;,4,(IF(CELL=quot;IV ABTquot;,4,0)))))
But after a certain amount it tells me there's an error. I will take any
help.

List your quot;services together in an unused portion of the workbook and in the
next collumn number (I would then name teh range where they are) them and
use a VLOOKUP

VLOOKUP(CELL,listrange,2,0)

quot;Breesmomquot; gt; wrote in message
...
gt;I have a database with over 1,000 rows and 13 columns. One of the column
gt; headings has a listing of about 23 different services. They want to add a
gt; column basically assigning a number to each service....I know I can use
gt; the
gt; IF function but apparently only for up to 8 arguments. Does anyone know
gt; if
gt; there's a way to add more?? Is there a better formula for this?? Or can I
gt; maybe lump three services???
gt;
gt; A quick example of what I'm talking about
gt;
gt; Services
gt; NEB
gt; CTH
gt; IV
gt; IV ABT
gt; NEB
gt;
gt; Say that's the list. I want to assign NEB's as a 1, IV and IV ABT as a 4.
gt; I know I can use =IF(CELL=quot;NEBquot;,1,(IF(CELL=quot;IVquot;,4,(IF(CELL=quot;IV
gt; ABTquot;,4,0)))))
gt; But after a certain amount it tells me there's an error. I will take any
gt; help.