Auto Fill Cell Based on Data in a different cell

[JB Bates]

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

 

[bill kuunders]

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                                                                                       

enter in C4 ....=IF(B4="","",C3)

this will do what you asked for, for one line, but
if you do enter names into the C column cells you will
loose the formula.............
you may have to setup your sheet differently.
greetings from New Zealand

 

[JLatham]

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]

Hi Bill - 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

 

[JB Bates]

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