Index Help

[iRon924]

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]

One way:

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

copy to C9, C15, etc.

 

[iron924]

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