I had cramped wt the fx in Excel! Luckily that there is a collegue, Hamdan, of mine assist me on this.
Should you need to drag a cell with let see want to maintain the 1 set, but move in sequence another 1 set, here is how it goes.
Usually, should you drag a fx of '=VLOOKUP(L205,AZ5:BA6,2,TRUE)' down, the result is like below.
=VLOOKUP(L205,AZ5:BA6,2,TRUE)
=VLOOKUP(L206,AZ6:BA7,2,TRUE)
=VLOOKUP(L207,AZ7:BA8,2,TRUE)
=VLOOKUP(L208,AZ8:BA9,2,TRUE)
=VLOOKUP(L209,AZ9:BA10,2,TRUE)
=VLOOKUP(L2010,A105:BA11,2,TRUE)
Luckily, it can be like this, if you need to.
=VLOOKUP(L205,AZ5:BA6,2,TRUE)
=VLOOKUP(L206,AZ5:BA6,2,TRUE)
=VLOOKUP(L207,AZ5:BA6,2,TRUE)
=VLOOKUP(L208,AZ5:BA6,2,TRUE)
=VLOOKUP(L209,AZ5:BA6,2,TRUE)
=VLOOKUP(L2010,AZ5:BA6,2,TRUE)
Bear in mind that only 'L' is moving in sequence, while others remain in the same.
How?
highligh the area that you want to remain (for instance above you need to highligh AZ5:BA6), and press F4 button. Then you can drag down the cell to get result as below.
=VLOOKUP(L205,AZ5:BA6,2,TRUE)
=VLOOKUP(L206,AZ5:BA6,2,TRUE)
=VLOOKUP(L207,AZ5:BA6,2,TRUE)
=VLOOKUP(L208,AZ5:BA6,2,TRUE)
=VLOOKUP(L209,AZ5:BA6,2,TRUE)
=VLOOKUP(L2010,AZ5:BA6,2,TRUE)