Dear all excel experts,
I have tried to use INDEX and MATCH yet still can't figure this out:
Table 1:
<colgroup><col><col></colgroup><tbody>
Remark
Currency Amt
Vchr# 100799, Pymt ID# flliqtaxcc0558902062, Supplier: Dept. of Bus. & Pro. Regulation, Cash Acct - A/P Acct
67,999.13
Vchr#...