Hi All

Again come back with new problem

i want to create a macro addons file like

if i put
gc result should be GIRLS 100% COTTON KNITTED CARDIGAN
gd result should be GIRLS 100% COTTON KNITTED DRESS
wc result should be WOMAN 100% COTTON KNITTED CARDIGAN
gs result should be GIRLS 100% COTTON KNITTED SWEATER
bs result should be BOYS 100% COTTON KNITTED SWEATER
gp result should be GIRLS 100% COTTON KNITTED PULLOVER
bp result should be BOYS 100% COTTON KNITTED PULLOVER

I I WOULD LIKE TO ADD MUCH MORE EVERY DAY. IT IS NOT POSSIBLE TO CREATE BY VLOOKUP FORMULA COZ I SHOULD BE USE IT MULTIPLE/MORE FILE.