Having got a working solution, to a previous question, which is only hampered by the IT Policy, I am looking for a VBA work around. The original problem:
Please see the Excel workbook for further details - warning contains a formula which requires the Morefunc add-in
I am trying to match a list of items(Column C) to a given location(Column A), to help with future amendments to both the location and list of items I would like to refference a refference type table. Its this arrangement between the data and the refference table that makes me think of a VLookup?
A full example can be seen in the workbook, where column E refferes to what I would like to be left with. Each item has its own unique code and is in the following format:
The solution, which works is the use of the MCONCAT function from the Morefunc add-in, with the following:
I have had a Google search of the VBA functionality for the AConcat as suggested, but VBA is outside my comfort zone.