On Mon, 23 Jan 2006 16:10:40 -0600, Morrigan
wrote:


I have a row of cells, for instance A1:BZ1, which can be blank or
number. I am able to output the right most cell with the formula:

LOOKUP(9.99999999999999E+307,A1:BZ1)

Is there a similar formula that allows outputting the left most cell
that contains a number?


Thank you in advanced.

One method:

Use the *array* formula:

=INDEX(A1:BZ1,1,MATCH(TRUE,ISNUMBER(A1:BZ1),0))

To enter an array formula, after typing or pasting it into the cell, hold down
<ctrl<shift while hitting <enter. Excel will place braces {...} around the
formula.


--ron