How to cluster together variables in an IF statement

[ks100]

Right now I have:

Please Login or Register  to view this content.

On a userform, there are a bunch of text boxes where you can enter in as many names as you want to search against X.

For example, you could fill in the first three of the text boxes with "Jim" "John" and "Larry" and n1 would = Jim, n2 = John and n3 = Larry. So basically the formula is checking

Please Login or Register  to view this content.

What I would ALSO like to do, is have the ability for someone to enter in "James" in one of the text boxes.

James is the supervisor of Jim, John, and Larry. So I want it to where if you only fill in one text box with the value of "James", the script would automatically have the formula checking to see if X = (Jim, John, or Larry).

I get that I could just say

Please Login or Register  to view this content.

but I didn't know if there was an easier way to do this.

I would like to cluster it even further, to where let's say I have "Alex", who is the boss of James, as well as "Frank".

I would like entering "Alex" in one of the textboxes to automatically check the names of all subordinates under Frank and James against X. There may be continuing levels to this chain.

I also would like to group it by department, such as "Finance" would check all the names in the Finance list against X.

What is the easiest way to accomplish this?

[Norie]

Not sure what you mean by 'cluster' but I would start by using an array for the names you want to search/check for.

[ks100]

Not sure what you mean by 'cluster' but I would start by using an array for the names you want to search/check for.

Yes an array seems to make sense. How do I tell the script to do:

Please Login or Register  to view this content.

?