I have a spreadsheet that I use the vlookup command. However, I have 23
lines per payroll check per employee - I am getting the data I want. However
it has 23,000 lines. The formula is on all lines but the column Index #
chaning to pull the correct information. Is there a way to copy this forumla
but have it change the column Index # automatically, instead if me manually
change each column when necessary. Example below - hopefully this will clear
up any confusion.

=VLOOKUP(A2,'D:\leblanc\PAYROLL\[paytst50-mod.xls]paytst50'!$A$2:$Y$1522,8,0)
=VLOOKUP(A2,'D:\leblanc\PAYROLL\[paytst50-mod.xls]paytst50'!$A$2:$Y$1522,9,0)
=VLOOKUP(A2,'D:\leblanc\PAYROLL\[paytst50-mod.xls]paytst50'!$A$2:$Y$1522,10,0)

=VLOOKUP(A2,'D:\leblanc\PAYROLL\[paytst50-mod.xls]paytst50'!$A$2:$Y$1522,11,0)