PDA

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.