Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 02:41 AM.


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