Forum Discussion
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...
I'm not sure if I understood it correctly, but here's an example (with Excel 2016)...maybe that's what you're looking for 
.
Yes this works but is quite complicated. Thanks.
