See if this helps:
http://www.officearticles.com/excel/...ft_excel.h tm
Your formula would be more like: =INDIRECT("C"&A1)
So, if you have a 4 in cell A1, this will return the contents of C4.
************
Anne Troy
www.OfficeArticles.com

"vidhya" wrote in message
...
hello
in one of excell sheets i have formula in one cell. in this formula i
have
a reference to a cell whose row number is the data contained in another
cell.
how do i extract this data to reference my destination cell.
thanking in advance