search across row for nearest value

G

Guest

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.
 
G

Guest

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
 
T

T. Valko

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

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)
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Across Multiple Rows / Columns 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Search for specific text within last non blank cell in a range 2
check if any values on row 7
Return of value when copying a formula 4
sumif and translate annual hours into weekly quarter hours 21
how can I pick up a nearest value to zero 3
Create a formula by joining text and the value from a formula 3

Top