Formula to reference column heading

J

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
 
F

Frank Kabel

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
 
Top