Just use the specific range:

=MAX(C10:AA10)

=LOOKUP(REPT("z",255),H133:Z133)


--
Biff
Microsoft Excel MVP


"Wolf Crick" wrote in message
...
Thanks. Now my question changes to how do I find that value in a specific
range on a row?

"T. Valko" wrote:

search across a row of empty cells to find
the one cell that has a value

If the one value is a number and the row is row 1:

=MAX(1:1)

If the one value is a TEXT entry:

=LOOKUP(REPT("z",255),1:1)

--
Biff
Microsoft Excel MVP


"Wolf Crick" <Wolf wrote in message
...
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.