How to increment row value in an index function in excel

Question

I display the dataset in the picture. In essence, I want to drag the GDP values for each country from (F:27-F:40) into row 5, but I am unable to do so. Where should I start? Remember that I need a formula so I can change the data.

Answer 1

Try this-

=INDEX($F$27:$F$40,COLUMN(A$1))

It will automatically increase the row number when you drag and across right.

If the country name is the same for both places then you can use the INDEX()/MATCH() combination.

=INDEX($F$27:$F$40,MATCH(B$1,$B$27:$B$40,0))