Thread: [Solved] Indirect Reference?
View Single Post
 
Old 08-25-2015, 06:13 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You could combine it with an OFFSET function, like:
Code:
=OFFSET(INDIRECT("'"&$A1&"'!A1"),ROW()-1,COLUMN()-1)
You can replace ROW()-1 & COLUMN()-1 with whatever other functions/values you require to get the desired results.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote