Excel Function Help

[lehainam]

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

[mangesh_yadav]

=INDIRECT(A1&"!C28")

Mangesh

[lehainam]

Dear Mangesh,

I tried but it didn't work.

Thanks,

Nam

[mangesh_yadav]

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

Mangesh

[lehainam]

Dear Mangesh,

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

Regards,

Nam

[mangesh_yadav]

Both formulae work for me.

Mangesh