![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tinfanide | Excel | 2 | 08-28-2015 05:11 PM |
![]() |
Ntema | Excel | 4 | 10-14-2013 08:49 AM |
![]() |
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 |