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.

Try in say, A2, array-entered*:
=INDEX(1:1,MATCH(TRUE,(1:1<""),0))
which returns the value from row1

*press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Wolf Crick" wrote:
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.

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.

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.

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.