Quote:
Originally Posted by harky
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.