=IF A2 Can Be Found in Column B, Enter Value from Column Z

Thanks for checking out this simple problem...for you. For me of the fried brain....ugh.

If the value in A1 is located somewhere in Column B (cell B7, for instance), then, for the Love of God, enter the value from Column Z (cell Z7), if not "".

Thanks, Jon

ConnectionLost, the next time I'm passing through Victoria, I'll buy you a drink. Yeah, uh-huh, that did it lickity-split! Thanks!