I am looking for a function that will search across a row of empty cells to
find the one cell that has a value; and then bring that value to the formula.

Additionally, I am looking for a function that will search across a row of
empty cells to find the nearest cell that has a value; and then return that
value.