We are trying to work out a formula for our purchase order system.
Currently we are receiving part ship PO's that are then placed in different locations, when searching for the locations it is only detailing the latest shipment. I would like the formula to search all of the fields (in sheet2) to display all locations to each unique PO numner.
I have included an example to help.
Thanks in advance.
Bookmarks