Index first cell with numeric value non-string in row.

[jimmyi189]

Hi everyone. I want to write a nested if statement with an OR in it. my goal is to index the first cell that has a numerical value. For example

A B C D E F G
Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14
$1,152.00 $1,152.00 $1,344.00 $576.00 $384.00 $576.00
$384.00 $384.00 $384.00 No Bill No Bill No Bill
No Bill No Bill No Bill $765.00 $765.00 No Bill

Say the row with the months is row 1.
II would want G2 to display $576, G3 to display $384.00 and G4 to display $765.00. I'm struggling with the syntax of the nested If and OR function.

[Ron Coderre]

Using your posted example...
this regular formula, copied down, returns the last numeric value in the referenced range

Please Login or Register  to view this content.

Is that something you can work with?

[jimmyi189]

That worked perfectly. I consider my self at an intermediate level when writing function statements. Is it possible to explain the 10^10. Thank you so much. You are a gentlemen and a scholar.

[Ron Coderre]

Regarding this formula:
=LOOKUP(10^10,A2:F2)

1) the LOOKUP function has a neat feature. If the lookup value is larger than every value of the same type (numeric or text) in the lookup range...it matches on the last value of that type.
2) If you want to use the largest number that Excel can handle, use: 9.99999999999999E+307
However, that's more typing than I prefer. Consequently, I use 10^10...which works for every application, except maybe astronomy