If in cell A5 I insert the value n I need that the value in B5 it is =worksheet!Bn.
Changing the value in A5 i should have a different value related to B5
If in cell A5 I insert the value n I need that the value in B5 it is =worksheet!Bn.
Changing the value in A5 i should have a different value related to B5
Try this:
=INDIRECT("worksheet!B"&A5)
Never use Merged Cells in Excel
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks