Thanks, HTH; that's the ticket.

PhillyRon

"Toppers" wrote:

TRY:

=IF((MOD(ROW(),3))=0,INDIRECT("E"&ROW()-2)," ")

HTH

"PhillyRon" wrote:

Hi guys--

I have an Excel database with a 3-cell address field that I need to parse
into other cells. Here is what I have so far:

=IF((MOD(ROW(),3))=0, E(ROW()-2), " ")

What I want to do is, every 3 rows (say I'm in row190) to put the contents
of E187 in the current cell. The "mod" part is working OK, but how do you
construct the "E187" cell reference? So far, no luck.