=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