ExcelBanter - Index Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Index Help (https://www.excelbanter.com/excel-worksheet-functions/212270-index-help.html)

iRon924

Index Help

I am trying to get an Index function to work and having some difficulty.

In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from
sheetA, cell E19, (then E33, E47, E51)...

Any ideas? Thanks in advance.

JE McGimpsey

Index Help

One way:

SheetB!C3: =INDEX(SheetA!E:E,(ROW()-3)/6*14+19)

copy to C9, C15, etc.

In article ,
iRon924 wrote:

I am trying to get an Index function to work and having some difficulty.

In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from
sheetA, cell E19, (then E33, E47, E51)...

Any ideas? Thanks in advance.

iRon924

Index Help

JE, that worked beautifully! Thanks so much for the help!

"JE McGimpsey" wrote:

One way:

SheetB!C3: =INDEX(SheetA!E:E,(ROW()-3)/6*14+19)

copy to C9, C15, etc.

In article ,
iRon924 wrote:

I am trying to get an Index function to work and having some difficulty.

In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from
sheetA, cell E19, (then E33, E47, E51)...

Any ideas? Thanks in advance.

All times are GMT +1. The time now is 09:34 AM.