I need a function that scans from the current position or range of cells in order vertically and/or horizontally and looks for the first non-blank value it finds and returns it. Is there such a function, I looked and looked and couldn't find one.

Thanks,

Devin