I will use an index funktion but my columns change position, i can look up numbes the columns with match funktion. (examble Columns A=1 E=5)
Therefore i want to put this column numbers i to the index funktion.
normal
=index(A:A,1,1)
Columns numbers come from a other cell
=index(columns number,1,1)
How i do that ?
You need to provide an example of the values in the "other cell".
Ben Van Johnson
In your example
I2 =INDEX(INDIRECT(ADRESS(1,Column()-8)&":"&ADRESS(5000,Column()-8)),1,1)
5000 is the numbers of rows in column A.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks