VlookUp: how to loop it? I am not an experienced user of Excel because I usually use python but I am obliged to use it this time.

This is the big picture of my case.

The problem is: 

I have a sheet with a column with some words, another column with the translation of these words in a non standard written way because they are written using numbers (such as "sale" will be "5413") and they are aligned with the corresponding standard written words (i.e. "sale").



In another sheet I have the same non standard written words (first column) that are sorted from 0 to 9 and there are also some numerical values associated to them.



My goal is:
take the values of the second sheet and put them in the order of the first sheet so that I can have the values of the non standard written words in the same order of the standard written words.

Someone suggested me to use the VlookUp function. 

=VLOOKUP($D2;$'leet_nopunct (2)'.$2:$1000;**97**;0)


It works! But I have to change the second last number (here 97) every time for each column of the second sheet and it is a very long process.

I know that Excel can use some macro: is there a way to loop this number in order to be automatically incremented it?
If you use a combination of INDEX and MATCH, you can let the desired look up array vary automatically as you drag the function across your columns, which is an alternative to manually fixing the look up column in VLOOKUP.

If you wish to continue with VLOOKUP, you could potentially add column numbers to the top of your data table, and reference these numbers instead of the hard-coded 97.