This returned a value of "37741" no matter which cell I
put it in. That won't work either.

Thanks so much for trying.

Allison


-----Original Message-----
Hi Allison,
Try this
=IF(ISBLANK(D1),"
",INDEX(D1:P1,1,13-2*(ISBLANK(D1)+ISBLANK(F1)+ISBLANK(H1)
+ISBLANK(J1)+ISBLAN
K(L1)+ISBLANK(N1)+ISBLANK(P1))))
It is not pretty but it works. I tried for a neater
solution but wanted
something general since we know nothing about the
intervening cells. Maybe
the true gurus will give us a better solution.
Bernard

"Allison" wrote in
message
...
Excel 2002

I need to return in column Z the last non-blank value in
columns D, F, H, J, L, N, P, R, T, V, X (every other
column starting with D) [or conversely, the first non-
blank working backward from column z and hitting every
other column].

I can use nested IF statements using ISBLANK(X3), but
only
up to 7 and I need 11.

What formula (or VBA if a formula isn't possible) could
I
use to accomplish this?

Thanks for any help!


.