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