Return next value in list matching criteria

Hi   I have a list per the below and I want to use a formula to find a value according to the bank criteria.    For example for each bank "BNZ" I want to bring in the corresponding amounts.   W...