Foncesa
06-25-2013, 12:19 PM
Hello,
I need a BIG help with this. How do I translate this to a vba code? & create a for loop for this till END.
{=IFERROR(INDEX($A$1:$A$15,MATCH(C2,IF($B$1:$B$15=2001,$C$1:$C$15),0)),IFER ROR(INDEX($A$1:$A$15,MATCH(C2,IF($B$1:$B$15=1001,$C$1:$C$15),0)),INDEX($A$1 :$A$15,MATCH(C2,IF($B$1:$B$15=1101,$C$1:$C$15),0)))}
I need a BIG help with this. How do I translate this to a vba code? & create a for loop for this till END.
{=IFERROR(INDEX($A$1:$A$15,MATCH(C2,IF($B$1:$B$15=2001,$C$1:$C$15),0)),IFER ROR(INDEX($A$1:$A$15,MATCH(C2,IF($B$1:$B$15=1001,$C$1:$C$15),0)),INDEX($A$1 :$A$15,MATCH(C2,IF($B$1:$B$15=1101,$C$1:$C$15),0)))}