Try this...

Data Range
A
B
1
BOY FORMAL SHOE, LEATHER,VELCRO Black 34
Boy
2
BOY SCHOOL SHOE, LEATHER,LACES Black 41
Boy
3
BOY SCHOOL SHOE, LEATHER,LACES Black 42
Boy
4
GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 28
Girl
5
GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Black 29
Girl
6
GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Maroon 26
Girl
7
GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 26
Girl
8
GIRLS GLADIATOR SANDALS OVERSTRAP WITH ZIP Red 28
Girl
9
KIDS GIRLS DOLL SHOE Bronze 11
Girl
10
KIDS GIRLS DOLL SHOE Bronze 1
Girl
11
KIDS GIRLS DOLL SHOE Bronze 12
Girl
12
KIDS GIRLS DOLL SHOE Bronze 13
Girl


This formula entered in B1 and copied down:

=IFERROR(LOOKUP(1000,SEARCH({"Boy","Girl"},A1),{"Boy","Girl"}),"")