Lookup With 2 Index Directly

[muhammad susanto]

hi all...

how to make lookup formula with 2 index (id_1 & id_2) like this :

id_1	tipe	id_2
4010106010	Buliding A	1
4010202007	Buliding B	1
4010205001	Permanent	49
4010202004	Resident	1
4010205001	Houses	46
4010205001	Houses	38
4010205001	Houses	42
4010205001	Houses	51
4010205001	Houses	55
4010205001	Houses	59
4010205001	Houses	63
given (id_1)	given (id_2)	expected result
4010202007	1	Buliding B
4010205001	46	Houses
		etc…

<colgroup><col><col><col></colgroup><tbody>
</tbody>

any help greathly appreciated...

m.susanto

 

[muhammad susanto]

here using Array :

=INDEX($E$3:$E$13;MATCH(D18&E18;$D$3:$D$13&$F$3:$F$13;0))

how to use without Array?