I need to get the value of a cell off one worksheet where the cell address
is on another sheet.
I have tried this:
=CONCATENATE("'Vendor Totals'!",Sheet1!I3)
Even tried Indirect()
Thanks for the help.
Carl
I need to get the value of a cell off one worksheet where the cell address
is on another sheet.
I have tried this:
=CONCATENATE("'Vendor Totals'!",Sheet1!I3)
Even tried Indirect()
Thanks for the help.
Carl
Worksheet references enclose in brackets (i.e. [MySheet.xls]
Tab names include ! after references (i.e. Sheet1!)
So your formula would be:
='[MySheet.xls]Sheet1'!A1
Now, if you have a cell reference in A1 in tab Sheet1 in MySheet.xls you
would need to format your indirect formula like so:
=INDIRECT('[MySheet.xls]Sheet1'!A1)
However, the reference in this A1 cell would need to follow the same format.
--
Regards,
Dave
"C Brehm" wrote:
> I need to get the value of a cell off one worksheet where the cell address
> is on another sheet.
> I have tried this:
> =CONCATENATE("'Vendor Totals'!",Sheet1!I3)
>
> Even tried Indirect()
> Thanks for the help.
> Carl
>
>
>
=indirect("'Vendor totals'!"&sheet1!i3)
or
=indirect(CONCATENATE("'Vendor Totals'!",Sheet1!I3))
C Brehm wrote:
>
> I need to get the value of a cell off one worksheet where the cell address
> is on another sheet.
> I have tried this:
> =CONCATENATE("'Vendor Totals'!",Sheet1!I3)
>
> Even tried Indirect()
> Thanks for the help.
> Carl
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks