Dear Experts,
Let say I have similar company name, document no. and reference no., only different in PIC, how can I not get the first amount 80000 when i vlook the company against the document no.? I just couldnt get the vlook with exact formula up... please help. Thank you.
Let say I have similar company name, document no. and reference no., only different in PIC, how can I not get the first amount 80000 when i vlook the company against the document no.? I just couldnt get the vlook with exact formula up... please help. Thank you.
Company Name | Document No. | Reference No. | PIC | Amount |
ABC Pte Ltd | 99770000123 | 12345678 | Michael | 80000 |
ABC Pte Ltd | 99770000123 | 12345678 | James | 100000 |