I have used the LOOKUP function before for such things but I am struggling
for a proper formula, using LOOKUP or otherwise, to grab the value of the
next lower cell in a column without an #N/A value.

So,

#N/A
#N/A
23.65

would return 23.65

Any ideas would be appreciated... my thanks in advance.

Brad