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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Try using INDIRECT, such as:

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

Hope this helps.

Pete
 
Back
Top