IF x = this or x = that x = thisthat or x = thisthatthis (where or comes from array)

[ks100]

In a spreadsheet there are columns with names in the first row.

Bob's column may include Jim, Jan and Tom, etc.


Let's say Bob is in the B column... and Jim, Jan and Tom are in rows 2 through 4 respectively (Bob is in the first row as the header title).

In this case, the script should go

Please Login or Register  to view this content.

I want it to check cell.value to see if it matches any of the names in Bob's column, to where I can just add a name to Bob's column directly on the spreadsheet by hand and it will automatically check that name when Bob's list is referenced.


It will need to get a little more advanced than this as well... there is a userform with about ten textboxes on it. In each of the ten text boxes, the user can type a name (such as Bob) and when the process is ran, the script will check all ten boxes for names, and then check each name just like it did Bob's.

So if

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

then the script would check cell.value for all the names on Bob's AND Harry's column, and perform (the same action) if any one of those names found a match.

I basically want to make it to where you can enter up to 10 names at a time, and it will check cell.value for all the people under each name entered's column.

Would I use an Array to do this? If so how does that work?

[Kaper]

to check this
I want it to check cell.value to see if it matches any of the names in Bob's column
use

Please Login or Register  to view this content.

With a number of tests -> just run then in a loop.