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