View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jambruins Jambruins is offline
external usenet poster
 
Posts: 65
Default Indirect or Index or something else

In column A I have text and I also have a sheet that corresponds to the text
in column A. For example, in cell A2 I have ARZ and there is also a sheet
called ARZ. I would like a formula in cell B2 to go into the sheet called
ARZ and pull the text from cell R1. Any idea how to do this? Thanks.