Function, or Group of Functions, That Allow You to Search a Dynamic Table?

I was wondering if there was a simpler way of searching for the value that can appear in multiple cells depending on user input?  Under normal circumstances two "Blocking" wouldn't exist, bu...