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 1,528 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))`
• 63,720 points

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

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

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

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

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