How to increment row value in an index function in excel

0 votes

IMAGE LINK: https://i.stack.imgur.com/J0rEK.png

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.

Nov 16 in Others by Kithuzzz
• 20,660 points
34 views

1 answer to this question.

0 votes

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))
answered Nov 17 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
119 views
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
74 views
0 votes
1 answer
0 votes
1 answer

Excel - IF combined with Index Match

Try: =IFERROR(IF(ISNUMBER(O2),VLOOKUP(A2,Sheet2!$C$2:$E$10,3,FALSE),""),"") =IFERROR(IF(ISNUMBER(O2),INDEX(Sheet2!$E$2:$E$10,MATCH(A2,Sheet2!$C$2:$C$10,0)),""),"") where the first "" means that O2 is not a number, ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
22 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

How to find index from raw and column in python?

You probably want to use np.ravel_multi_index: import numpy as ...READ MORE

answered Sep 12, 2018 in Python by Priyaj
• 58,100 points
448 views
0 votes
1 answer

How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

answered Nov 24 in Others by narikkadan
• 37,660 points
27 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
27 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP