X lookup or index match with 2 conditions

[Cervani]

Hello, as per below table, can I get some formula calculating in "Result I want to get"please

table 1
code	Town	Result I want to get
27J	Sacramento	sold
27J	Sacramento	sold
27J	Sacramento	sold
27J	New York	waiting
27J	New York	waiting
26J	Denver	no data
26J	Denver	no data
24J	Sacramento	Approved
Table 2 with values to match
code	town	status
27J	Sacramento	sold
27J	New York	waiting
24J	Sacramento	Approved

 

[gargamalebarbosa]

 

[AhoyNC]

Another option with Excel 365 is the FILTER function.

Book1
	A	B	C
1	table 1
2	code	Town	Result I want to get
3	27J	Sacramento	sold
4	27J	Sacramento	sold
5	27J	Sacramento	sold
6	27J	New York	waiting
7	27J	New York	waiting
8	26J	Denver	No Data
9	26J	Denver	No Data
10	24J	Sacramento	Approved
11
12
13	Table 2 with values to match
14	code	town	status
15	27J	Sacramento	sold
16	27J	New York	waiting
17	24J	Sacramento	Approved
Sheet1

Cell Formulas
Range	Formula
C3:C10	C3	=FILTER($C$15:$C$17,($A$15:$A$17=A3)*($B$15:$B$17=B3),"No Data")

 

[Cervani]

Thanks both,
Filter is cool but when I Filter column after this formula it doesn't keep reference.