Reference in a vlookup trying to understand what it is looking for?

where D$1 is should be the column number for the range $A:$H
so D$1 should hold a number between 1-8 if the formula is dragged across a row it will change to E$1
so similarly F$1
hold a number between 1-8 so maybe someone has put something like 1,3,5,7,8,2,4,6 in d1::k1
so when the formula is dragged across it will return from that the results in that order

I may be able to build on this response.

Imagine we have the following table of data:

	A	B	C
1	one	two	three
2	nine	ten	eleven

If we use a VLOOKUP of:

Please Login or Register  to view this content.

then it will produce a result of "eleven"

- "nine": this is the variable that the equation searches for in the first column of the table you passed in to it. In our case, it looks only in A1:A2
- A1:C2 : this is the full table of data that we pass to the equation
- 3 : this is the column from the table that we want returned to us from the row where column A holds "nine"
- FALSE : this indicates we want an exact match for "nine". TRUE would indicate an approximate match.

I hope that helps