how do i use the data in one cell as the row number of another cel

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

See if this helps:
http://www.officearticles.com/excel/...soft_excel.htm
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" <vidhya@discussions.microsoft.com> wrote in message
news:BBC51432-C611-41FD-9BD8-FB503DE8C76F@microsoft.com...
> 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

Hi
Try using in INDIRECT function.
e.g..
A1=225
B1=A
C1=1

to extract the value in A1 using both B1 and C1 has your reference then:
=INDIRECT(B1&C1)

or if you already know your column reference, "in this case A" then:
=INDIRECT("A"&C1)

HTH
JG