Thread
:
Indirect with hlookup
View Single Post
01-05-2016, 08:35 AM
jamesjts
Windows 8
Office 2013
Novice
Join Date: Jan 2016
Posts: 2
Does not work give me #REF!, when I open the formula it shows volatile for the indirects
Quote:
Originally Posted by
xor
Maybe:
=HLOOKUP(INDIRECT("'"&$A1&"'!$F$1"),INDIRECT("'"&A 1&"'!$J$1:$M$2"),2,FALSE)
jamesjts
View Public Profile
Find all posts by jamesjts