 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 190 views

## 1 answer to this question.

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))`
• 51,600 points

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

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

## 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

## 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

## 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

## Calculate the mean from excel sheet for specific rows

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

## 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