Some may suggest Indirect(), which is volatile, and the inferior solution.
Try
=INDEX(Sheet2!$A$3:$Z$3,1,ROW(A1))
and copy down.
cheers,
Some may suggest Indirect(), which is volatile, and the inferior solution.
Try
=INDEX(Sheet2!$A$3:$Z$3,1,ROW(A1))
and copy down.
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks