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, 2022 in Others by Kithuzzz
• 38,010 points
1,494 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, 2022 by narikkadan
• 63,720 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, 2022 in Others by narikkadan
• 63,720 points
864 views
0 votes
1 answer

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

answered Dec 28, 2022 in Others by narikkadan
• 63,720 points
1,165 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,720 points
358 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

answered Apr 6, 2023 in Others by narikkadan
• 63,720 points
560 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, 2022 in Others by narikkadan
• 63,720 points
566 views
0 votes
1 answer

Calculate the mean from excel sheet for specific rows

Generate a list for each means you ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,720 points
609 views
0 votes
1 answer

Excel Lookup function for text

Use a simple VLOOKUP() function like: =VLOOKUP(E2,$A$2:$B$6,2,FALSE) You can also use ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,720 points
388 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, 2022 in Others by narikkadan
• 63,720 points
1,177 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, 2022 in Others by narikkadan
• 63,720 points
3,380 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