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
• 27,940 points
190 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
• 51,600 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
• 51,600 points
103 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
• 51,600 points
61 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 51,600 points
1,106 views
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, 2022 in Others by narikkadan
• 51,600 points
229 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
• 51,600 points
84 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
• 51,600 points
57 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
• 51,600 points
56 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
• 51,600 points
133 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
• 51,600 points
232 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