Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Indirect with hlookup
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
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,101
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
  #2  
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
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


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 03:34 AM.

Contact Us - Privacy Statement - Top

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