Reference

  • Thread starter Thread starter gabriel
  • Start date Start date
G

gabriel

Hi :
I have a sheet with a table. (Sheet1)
I have another sheet where I use data of this table (Sheet2)
I want to put in a cell of sheet2 the row's number. Ej: A3: 12
and do a reference to the table on sheet1 with this number Ej:
!Sheet1(J(A3))
that will show this : !Sheet1(J12).
I can't do this....

Please help me,
Thanks
Gabriel
 
How about:

=INDIRECT("sheet1!j"&A3)


Hi :
I have a sheet with a table. (Sheet1)
I have another sheet where I use data of this table (Sheet2)
I want to put in a cell of sheet2 the row's number. Ej: A3: 12
and do a reference to the table on sheet1 with this number Ej:
!Sheet1(J(A3))
that will show this : !Sheet1(J12).
I can't do this....

Please help me,
Thanks
Gabriel
Click to expand...
 
Back
Top