Oct 26 2020 06:23 PM
Oct 27 2020 12:28 AM
@Eddy162 If you are on an Excel version that supports the new FILTER function, the attached file perhaps contains the solution you want. I've also added an alternative that gives the cost string and a notification if there are more than one for a PO.
Note, I've used a few named ranges to keep the formulae easier to read and maintain.