Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve