Dear Masters,
Ane punya kasus dimana ane ingin mengkonversi secara otomatis seperti berikut, | Awal | | | | | | | ID | Qty | Unit | konversi | Qty (in Kg) | | | 1000464 | 29,631.36 | KG | 1 | 29631.36 | . | | 1000464 | 4,938.56 | KG | 1 | 4938.56 | | | 1000445 | 118,800 | SHT | 0.123456 | 14666.5728 | | | 1000791 | 279,000 | SHT | 0.654321 | 182555.559 | | | | | | | | | | Yang diinginkan | | | | | | ID | Qty | Unit | Qty (in Kg) | | | | 1000464 | 29,631.36 | KG | | | | | 1000464 | 4,938.56 | KG | | | | | 1000445 | 118,800 | SHT | | | | | 1000791 | 279,000 | SHT | | | | | | | | | | | | | | | | | | | | | | | | | Jadi kolom "qty in kg" nya terisi otomatis dengan hasil vlookup kalau SHT dan di kali 1 kalau KG. Atas bantuannya ane ucapkan terimakasih, NB: data terlampir Salam, Lukman
DATA_konversi.xlsx
Description: MS-Excel 2007 spreadsheet
