Formula to reference column heading

[JimDandy]

Thanks for the quick reply. I looked at that function but could not se
how to use it to reference a worksheet with the name "03". It work
fine within the same worksheet but doesn't appear to be able to creat
a reference off sheet.

It could just be my misunderstanding of its correct use in my situatio
however, so if you could povide an example I would be grateful

 

[Guest]

Hi
if you want to reference for example the range A1:A100 on a separate sheet
and the sheet name is in Q3 try
INDIRECT("'" & Q3 & "'!A1:A100")

within the Sumproduct formula

 

[JimDandy]

Many thanks, Frank! That was just what I needed...