combining vlookup & hlookup

[jammer6_9]

How can I combine vlookup & hlookup?

=INDEX('DRILLDOWN DATA'!AZ,MATCH($A$4,A:A,0),MATCH($E$1,'DRILLDOWN DATA'!1:1,0))

[Bob Phillips]

Try

=INDEX('DRILLDOWN DATA'!$A:$DZ,MATCH($A$4,'DRILLDOWN DATA'!$A:$A,0),COLUMN())

[jammer6_9]

What a .... I was twisting the formula for almost an hour and you did in a minute ... 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]

Note, I amended it to make it more usable for all columns.

[jammer6_9]

Thanks xld. But that one I have managed

Note, I amended it to make it more usable for all columns.