Hi to all,
I have data in two sheets, both sheets contains 253 columns data
for example sheet1
A B C D E F
AA BB CC DD EE FF
Sheet2 contains
A B C D E F
BB FF CC DD EE AA
Now i want to get data from sheet1 to sheet2 for columns A to F and i am using vlookup function for it but i need to change column number everytime, so that i have change column number for 253 times and it will be problematic for me. Is there any to put movable column to this vlookup?,
=vlookup(lookupvalue,table array,columnnumber,match), i want to make columnnumber movable so that i can drag that formula with out any problem.
I need help to solve this problem and help would be appreciated.
Thanks
Regards,
Genetist
I have data in two sheets, both sheets contains 253 columns data
for example sheet1
A B C D E F
AA BB CC DD EE FF
Sheet2 contains
A B C D E F
BB FF CC DD EE AA
Now i want to get data from sheet1 to sheet2 for columns A to F and i am using vlookup function for it but i need to change column number everytime, so that i have change column number for 253 times and it will be problematic for me. Is there any to put movable column to this vlookup?,
=vlookup(lookupvalue,table array,columnnumber,match), i want to make columnnumber movable so that i can drag that formula with out any problem.
I need help to solve this problem and help would be appreciated.
Thanks
Regards,
Genetist