I have made a small example document with 2 sheets in it.
One called “delivery time” this will be a long list with many shipper and consignee numbers. They will be listed separated with commas in the columns B and C. This sheet will also include the delivery time in days depending of mode of transport and the date where the shipment is shipped.
The other sheet is names summary, and here is a single shipper, consignee, mode of transport and the shipping day. This is where I would like the column E to do the “magic function”.
It should find the row in “delivery time” where the mode of transport, shipping day, shipper and consignee is represented.
If only there was one consignee and one shipper per row in the delivery time sheet, I could do this, but I can’t get it to work when the cells contain comma separated lists. I have tried with search, index and match functions, but I can’t get these to search and return the right value :-(
Can somebody help me on this?
Bookmarks