Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2016, 06:33 PM
jamesjts jamesjts is offline Indirect with hlookup Windows 8 Indirect with hlookup Office 2013
Novice
Indirect with hlookup
 
Join Date: Jan 2016
Posts: 2
jamesjts is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-05-2016, 03:58 AM
xor xor is offline Indirect with hlookup Windows 10 Indirect with hlookup Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe:

=HLOOKUP(INDIRECT("'"&$A1&"'!$F$1"),INDIRECT("'"&A 1&"'!$J$1:$M$2"),2,FALSE)
Reply With Quote
  #3  
Old 01-05-2016, 08:35 AM
jamesjts jamesjts is offline Indirect with hlookup Windows 8 Indirect with hlookup Office 2013
Novice
Indirect with hlookup
 
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
  #4  
Old 01-05-2016, 09:13 AM
xor xor is offline Indirect with hlookup Windows 10 Indirect with hlookup Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

It works fine for me.
(INDIRECT is volatile).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indirect with hlookup Indirect Reference? tinfanide Excel 2 08-28-2015 05:11 PM
Indirect with hlookup Vlookup/hlookup Ntema Excel 4 10-14-2013 08:49 AM
Indirect with hlookup 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft