muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to make lookup formula with 2 index (id_1 & id_2) like this :
<colgroup><col><col><col></colgroup><tbody>
</tbody>any help greathly appreciated...
m.susanto
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>
m.susanto