So I got the following lookup:
The next column should have the samen lookup value(A20), but COLUMN(D:D) as column index number. And this continues for a couple of hundred columns.
Is this possible?
Yes it is, change this formula to
And then fill to the right. The
$ keeps the number or column letter from changing.