Conditional IF Statement to Auto Fill cells based on a Specific criteria

[Jyotirmaya]

I have values in F column & N column, the values of N column are depend on the F column data. Means there can be more than one value associated in F column with respect to the value of F.

For example

F2 Bike N2 Honda bike
F3 Car N3 Mercedes Car
F4 N4 BMW car
F5 Train N5 Diesel Train
F6 N6 Bullet Train
F7 N7 Electronic Train
F8 Laptop N8 Hp
F9 N9 Acer
F10 N10 Lenovo
F11 N11 Samsung

I have column C which is empty I want that
C2 bike
C3 Car
C4 Car
C5 Train
C6 Train
C7 Train
C8 Laptop
C9 Laptop
C10 Laptop
C11 Laptop

I want the column C to filled according to the number of cells associated in Column N with respect of Column F.

 

[oldbrewer]

so if EITHER or BOTH of F2 and N2 contain bike C2 = bike

if true, what if F2 contains bike and N2 contains train ?

 

[Jyotirmaya]

so if EITHER or BOTH of F2 and N2 contain bike C2 = bike

if true, what if F2 contains bike and N2 contains train ?

sorry I didnt get you but, whatever the text in N2 doesnt matters, I want the F2 text should be copied in C2 & so on

 

[Caribeiro77]

Maybe, in C2:

=IF(F2<>"",F2,C1)

 

[Jyotirmaya]

Maybe, in C2:

=IF(F2<>"",F2,C1)

ya thanks its working