Microsoft Office Forums - View Single Post - Indirect with hlookup

Thread: Indirect with hlookup

View Single Post

Old

01-05-2016, 08:35 AM

jamesjts

jamesjts is offline

jamesjts uses Windows 8

Windows 8

jamesjts uses Office 2013

Office 2013

Novice

The original poster

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