Try this:

Make a list of the Job Titles you are interested in flagging and name that
range:

Example:

D1: Supervisor
D2: Skilled
D3: Unskilled
D4: ThisJob
D5: ThatJob
D6: SomeJob

Name the range something like 'LU_JobTitle'.

Then, assuming the column of titles begin in cell A2) and you want the flags
in Col B, put this formula in B2 and copy down :

=IF(COUNTIF(LU_JobTitle,A2),"X","")
Or without the range name:
=IF(COUNTIF($D$1:$D$6,A2),"X","")


Does that help?

Ron

"timbo" wrote in message
...
I have 3 classifications of workers(supervisors,skilled, and unskilled) and
need to post a x in a cell by their jop title. I have been using the IF
funtion for years, but only had 5 or 6 job titles. Now with more job
titles,
I have surpassed the maximum of 7 nest funtions.