Excel Function Help
 

Dear all,

I have a sheet named "Nam" and I have another sheet in which cell
A1="Nam" and in this sheet I have a formular to get value from cell C28
of sheet "Nam". For example ='Nam'!C28.

My question is that Is there any function in Excel that I can get the
value from C28 of sheet "Nam" by using sheet reference from cell A1,
for ex. =A1 & cell reference.

Thanks a lot!


Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=381114

Excel Function Help
 

=INDIRECT(A1&"!C28")

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38111

Excel Function Help
 

Dear Mangesh,

I tried but it didn't work.

Thanks,

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=381114

Excel Function Help
 

What did the formula return, did it return #Ref! error...?
In cell A1, you should have Nam and not "Nam"

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381114

Excel Function Help
 

Dear Mangesh,

I think the formular should be =indirect(address(28,2,4,true,A1))

Regards,

Na

--
lehaina
-----------------------------------------------------------------------
lehainam's Profile: http://www.excelforum.com/member.php...fo&userid=1861
View this thread: http://www.excelforum.com/showthread.php?threadid=38111

Excel Function Help
 

Both formulae work for me.

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38111