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