View Single Post
  #1   Report Post  
C Brehm
 
Posts: n/a
Default Refrencing a variable cell in a formula

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