hlookup with combination

[sachin483]

i want to do hlookup with combtion of territory ie:- D:1 :E:1 with A2

TERR DSCR NAME 0034 0055
AX01 XYZ PLACE SONY 102 29096
AX05 XXX PLACE SIMON 602 29596

TERR DSCR ITEM NAME FLS
AX01 XYZ PLACE 0034 SONY
AX01 XYZ PLACE 0055 SONY
AX05 XXX PLACE 0034 SIMON
AX05 XXX PLACE 0055 SIMON

[HansV]

In E6:

=INDEX($D$2:$E$3,MATCH(A6,$A$2:$A$3,0),MATCH(C6,$D$1:$E$1,0))

Fill down.

[sachin483]

thanks a lot