copy using filter not working properly

[hai_krk]

I have this data in sheet 1
S.No Name COl2
1 A Apple
2 B Ball
3 C Cat
4 A Apple
5 B Ball
6 C Cat

In sheet 2 I have these columns
S.no Name Col2
1 A
2 B
3 A
4 A
5 B
6 B

In sheet 1, I filtered name column and copied apple and when I try to copy the same in sheet 2 (by filtering Name). Its not copying properly.Is there any other to copy other than using Vlookup.

[dragavs]

try this

=IF(RIGHT(A1,1)="A","Apple","")&IF(RIGHT(A1,1)="B","Ball","")&IF(RIGHT(A1,1)="C","Cat","")