looking up a cell via a formula

  • Thread starter Thread starter Beasley
  • Start date Start date
B

Beasley

There is a cell (c5) on my spreadsheet with a number
(11) in it. I want another cell (x5) to contain the
number that is found in cell (e105). I want to use the
formula {((c5)-1) * 10 + 5 } to designate the row number
of the cell for x5 to look in. How do I do this?
 
Put in X5: =INDIRECT("E"&(INDIRECT("C5")-1)*10+5)

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
 
Back
Top