Best way to cross populate multiple arrays based on data entry into a single array?

[mrmmickle1]

Orestees,

Try something like this:

=IF(ISNUMBER(SEARCH("*Tinker*",B3)),B24,IF(ISNUMBE R(SEARCH("*Tom A*",B3)),B24,"NoTrainerAvailable"))

You would need to enter all the possible trainers...

Or possibly just a nested if statement. The reason to use the * is to search for a string.