[SOLVED] Searching A Cell for multiple text strings (a whole list) with one formula?

Thanks to everyone for their answers. Special Thanks to John Topley, This VBA solution is exactly what I was searching for. THIS IS SOLVED!