#1
|
|||
|
|||
Indirect with hlookup
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 |
#2
|
|||
|
|||
Maybe:
=HLOOKUP(INDIRECT("'"&$A1&"'!$F$1"),INDIRECT("'"&A 1&"'!$J$1:$M$2"),2,FALSE) |
#3
|
|||
|
|||
Does not work give me #REF!, when I open the formula it shows volatile for the indirects
|
#4
|
|||
|
|||
It works fine for me.
(INDIRECT is volatile). |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Indirect Reference? | tinfanide | Excel | 2 | 08-28-2015 05:11 PM |
Vlookup/hlookup | Ntema | Excel | 4 | 10-14-2013 08:49 AM |
HLOOKUP, if,? OR MACRO | bobbyarnold | Excel | 22 | 01-14-2013 08:44 AM |
HLOOKUP with VLOOKUP into different Doc | freeman | Excel | 0 | 09-18-2012 02:04 PM |
Indirect | zleyphox | Excel | 1 | 02-11-2010 09:57 AM |