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.