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 |