How to automatic my INDEX and Match

[go14344]

how to automate this formula because i need to encode this till cell ATS,ATT,ATU

my formula for cell are:
cell cq my formula is this : {=INDEX(Form!$D$2:$D$10115,MATCH(Calc!$B$24&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}
cell cr my formula is this : =VLOOKUP($B$24,Load!$B:$D,3,0)
cell cs my formula is this : {=INDEX(Form!$C$2:$C$10115,MATCH(Calc!$B$24&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}

cell cu my formula is this : {=INDEX(Form!$D$2:$D$10115,MATCH(Calc!$B$25&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}
cell cv my formula is this : =VLOOKUP($B$25,Load!$B:$D,3,0)
cell cw my formula is this : {=INDEX(Form!$C$2:$C$10115,MATCH(Calc!$B$25&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}

and so on...... is there a way to automate this because i need to encode this till cell ATS,ATT,ATU..

cell ATS my formula should like this: {=INDEX(Form!$D$2:$D$10115,MATCH(Calc!$B$251&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}
cell ATT my formula should like this =VLOOKUP($B$251,Load!$B:$D,3,0)
cell ATU my formula should like this {=INDEX(Form!$C$2:$C$10115,MATCH(Calc!$B$251&Calc!$F3,Form!$A$2:$A$10115&Form!$B$2:$B$10115,0))}

hope someboday can help me... thanks

 

[BAlGaInTl]

So if I'm reading this right...

You have the same formulas repeating every 3 columns, except the middle one increases the row # by 1 each iteration?

What cells are these formulas going in? Is it just a single line across another sheet?