I have attached an example file, with working vlookup formula which Im trying to get rid of, so I do not need time to create pivotable to help the formula out.
What the working lookup is currently doing:
1) 1st worksheet contains list of settlements with amounts, there might be several...