I want to copy the below formula across columns with it only increasing the column by 1. However I will be skipping 3 columns each time. So when I copy its changing to column (H) and I need it to only increase to (E)
=INDEX(test!D$1:D$12, MATCH($A$1,test!$A$1:$A$12,0))
=INDEX(test!H$1:H$12, MATCH($A$1,test!$A$1:$A$12,0))
How can I copy this without having to manually change the columns?
=INDEX(test!D$1:D$12, MATCH($A$1,test!$A$1:$A$12,0))
=INDEX(test!H$1:H$12, MATCH($A$1,test!$A$1:$A$12,0))
How can I copy this without having to manually change the columns?