View Single Post
 
Old 01-05-2016, 08:35 AM
jamesjts jamesjts is offline Windows 8 Office 2013
Novice
 
Join Date: Jan 2016
Posts: 2
jamesjts is on a distinguished road
Default

Does not work give me #REF!, when I open the formula it shows volatile for the indirects

Quote:
Originally Posted by xor View Post
Maybe:

=HLOOKUP(INDIRECT("'"&$A1&"'!$F$1"),INDIRECT("'"&A 1&"'!$J$1:$M$2"),2,FALSE)
Reply With Quote