View Full Version : combining vlookup & hlookup
jammer6_9
05-02-2011, 02:06 AM
How can I combine vlookup & hlookup? :help
=INDEX('DRILLDOWN DATA'!A:DZ,MATCH($A$4,A:A,0),MATCH($E$1,'DRILLDOWN DATA'!1:1,0))
Bob Phillips
05-02-2011, 02:16 AM
Try
=INDEX('DRILLDOWN DATA'!$A:$DZ,MATCH($A$4,'DRILLDOWN DATA'!$A:$A,0),COLUMN())
jammer6_9
05-02-2011, 02:21 AM
What a .... I was twisting the formula for almost an hour and you did in a minute :thumb ... Thanks!
Try
=INDEX('DRILLDOWN DATA'!$A:$DZ,MATCH($A$4,'DRILLDOWN DATA'!$A:$A,0),MATCH($E$1,'DRILLDOWN DATA'!$1:$1,0))
Bob Phillips
05-02-2011, 02:31 AM
Note, I amended it to make it more usable for all columns.
jammer6_9
05-02-2011, 03:19 AM
Thanks xld. But that one I have managed :clap:
Note, I amended it to make it more usable for all columns.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.