How do I get a cell reference into this formula...

[Guest]

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.

 

[Pete_UK]

Try using INDIRECT, such as:

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

Hope this helps.

Pete

 

[Guest]

TRY:

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

HTH

 

[Guest]

Thanks, HTH; that's the ticket.

PhillyRon

TRY:

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

HTH