I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK
worksheet, heres my formula in cell C8
=IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if DEADLOAD!A20
is blank and A21(A21 instead of A20) has a value, and I want the result to be
on cell C8.. and if A21 is followed with a value at A22, I want the result to
be on cell C9.. Hope you get what I mean... thanks....

=INDEX(A:A,MIN(IF(A20:A30<"",ROW(A20:A30))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RYNNER" wrote in message
...
I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK
worksheet, heres my formula in cell C8
=IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if
DEADLOAD!A20
is blank and A21(A21 instead of A20) has a value, and I want the result to
be
on cell C8.. and if A21 is followed with a value at A22, I want the result
to
be on cell C9.. Hope you get what I mean... thanks....