VBA VLookUp 1 condition return in 1 cell multiple results.

Hello everyone,

I'm new to the VBA programming in Excel I have already try some numerous attempts but they take too long or they don't work at all.

I have included on this post 4 attachments:
- MainFile
- Weekly Kronoz
- Weekly Quartz
- Weekly Quartz-2017

In the Main File I'm using VLookUP to Look for the BK# and Retrieve the Dates for ATD and ATA as well as the Container Numbers in other Workbooks.

This work good so far the main problem is when it comes down to Container # since a BK# may have more than 1 Container #.

What I'm trying to do is a VBA Code to look for the BK # in all the different Workbooks and return all the Containers # available for that Bk# in a single Cell.

Lets say for Example if you open the MainFile I have B# 37607 and it currently has the Container # UACU5115709 which is okay since its only 1 container but lets say that B#37607 has more than one. Well I need the VBA code to return all Container # for that B# like UACU5115709, FSCU8825999, etc.

I would appreciate any help provided.

Thanks

Hello SistemasCalexico,

Welcome to the Forum!

There is a lot of different issues with these layouts. While the macro works with the examples provided, there may be issues with other workbooks. I have added a new worksheet to the Main workbook which will list the booking numbers and the containers associated with them. Only booking numbers that have shipping container numbers in BIC format are copied to the list.

Here is the macro that has been added to the attached workbook. You can run the macro using Alt+F8 to bring up the macro dialog.

Please Login or Register  to view this content.