Please look the following datas:-

Part No Description
1100661 OIL ENGINE 10 W 30 - SJ GRADE
31916-KST-920F SPARK PLUG
91302-KEV-9000F O-RING 30.8X3
95701-06110-00 BOLT FLANGE 6X110
90081-GFP-9000F BOLT SOCKET FLANGE 6 X 23
90701-GF6-0000 PIN DOWEL SPECIAL 8X14

I want to know the part no.having end with "F" in a separate column.The expected result should be as:-

31916-KST-920F
91302-KEV-9000F
90081-GFP-9000F

I am applying the following formula:-

Column C Column D
*F IF(C3="","",INDEX($A:$A,MATCH(C3,A:A,0)))
and the result is coming:-

31916-KST-920F
but when I copy the *F in C4 and the above formula in D4,the same result comes i.e.
31916-KST-920F.It should come 91302-KEV-9000F in D4 cell and 90081-GFP-9000F in cell D5.Can you help me for the desired result achieve?

Regards

Pradeep