Thread: can i use a cell value as another sheet's cell reference
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default can i use a cell value as another sheet's cell reference
Although I am not really sure, it seems you need the INDIRECT()
function. Something like:
INDIRECT("'boy-pres'!$C$" & Sheet1!C5).

Does this help?

Kostis Vezerides

Reply With QuoteReply With Quote