I had attach a code which i edit....

not sure hw i m going to explain


this is what i plan to put in my excel list....

WHen i choose any type on the RED highlighted,
colume A-F, H-M will be filled in automatic


but than i m not sure how am i going to key in on the one which highlighted on Orange..

can some1 advice me... i been search online to check how m i going to fill it but than... unable too

-------------------------------------------------------------------------
Dear harky, Good Morning.

Try this one:

A5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($A$13:$A $15,MATCH($G$5,$G$13:$G$15,0)))

B5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($B$13:$B $15,MATCH($G$5,$G$13:$G$15,0)))

C5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($C$13:$C $15,MATCH($G$5,$G$13:$G$15,0)))

D5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($D$13:$D $15,MATCH($G$5,$G$13:$G$15,0)))

E5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($E$13:$E $15,MATCH($G$5,$G$13:$G$15,0)))

F5 -- =IF(ISNA(MATCH($G5,$G$13:$G$17)),"",INDEX($F$13:$F $15,MATCH($G$5,$G$13:$G$15,0)))

Tell me if it worked for you.