Indirect with hlookup

[jamesjts]

My formula is =HLOOKUP('400'!$F$1,'400'!$J$1:$M$2,2,FALSE) I need to pull the sheet name from column A for both the lookup and the results so the '400' should come from column A which is "400". I need to be able to drag the formula down and have it reference $F$1 & $J$1:$M$2 cells for each sheet as listed in column A. I get error on everything I try. Any help is appreciated.
A | B | C | D
400 | Pacific | 4:53 PM | East Bay - CA
402 |Eastern | 7:53 PM | Metro NY - NY

[xor]

Maybe:

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

[jamesjts]

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

Originally Posted by xor

Maybe:

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

[xor]

It works fine for me.
(INDIRECT is volatile).