Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to reference column heading
Thanks for the quick reply. I looked at that function but could not see how to use it to reference a worksheet with the name "03". It works fine within the same worksheet but doesn't appear to be able to create a reference off sheet. It could just be my misunderstanding of its correct use in my situation however, so if you could povide an example I would be grateful. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=314401 |
#2
|
|||
|
|||
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" wrote: Thanks for the quick reply. I looked at that function but could not see how to use it to reference a worksheet with the name "03". It works fine within the same worksheet but doesn't appear to be able to create a reference off sheet. It could just be my misunderstanding of its correct use in my situation however, so if you could povide an example I would be grateful. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=314401 |
#3
|
|||
|
|||
Many thanks, Frank! That was just what I needed.... -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=314401 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
Formula to reference column heading | Excel Worksheet Functions |