View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_534_] Leith Ross[_534_] is offline
external usenet poster
 
Posts: 1
Default How can I use a cell value to reference a row?


Hello Excelchallenged,

In cell A10 place the formula...
=INDIRECT("J" & A5)

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=509173