Thread: Resolve a text cell reference to the cell's value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BCDS BCDS is offline
external usenet poster
  
Posts: 4
Default Resolve a text cell reference to the cell's value
I have 2 cells on a work sheet that I concatenate together in cell D27 to
give the string '#1'!P15 which refers to cell P15 on worksheet #1

D27="'"&D$24&"'!"&C27

I want to do this

=D27*E27

But I get the #VALUE! result

How do I get D27 to have the value of cell P15 on worksheet #1 instead of a
text string?
Reply With QuoteReply With Quote