Hi - thanks for the help. if there is no data in C3 it is giving me "0.0" in
C4 -- is there a way around this? JB

"JLatham" wrote:

In C4 enter this formula
=IF(B4<"",C3,"")
Fill down as required. But if I have read and understood correctly, that's
going to put GFA into column C on any row where there's an entry in column B.
So C4 and C5 will also contain GFA, with C6 remaining empty.


"JB Bates" wrote:


I am looking for a formula for column C to autofill the information from the
cell directly above BASED on data in Column B -- ie If cell B4 has data than
cell c4 will auto fill with the data in cell c3. if there is no info in the
correlating cell in column B the cell in column C will remain empty.

DEPART ARRIVE
ICAO ICAO PIC
KDPA KMDW GFA
KMDW KPBI
KPBI KDPA
KDPA


THANKS in advance -- JB