Partial Look up return multiple results

[jpsawadee23]

Hey,
seeking for your help help help...
Is the formula below possible?

A Cells contains document reference, B cells are the document amount, C cells are combination of document reference(text) and D cells are the Total amount.

Cell A1, A2, A3, lookup to Cell C1, C2, C3 but and the return value will be the difference of B1,B2,B3 and cell D1, D2 and D3.

A1 contains is 4333, A2 2222, A3 28743;

B1 6,634.12 B2 316.87 B3 3,452.12

C1 is 5673.2122.4333.5678; C2 is 4333.3211.6541.2222; C3 3211.4333.2211.8734

D1 56,455.21 D2 67,899.10 D3 120,231.69



Thank You