Hi all new to this so please excuse me if this has been covered already.
Column A is a list a numerical codes and Column B is a list of names sadly codes aren't unique to the name. I have ran a pivot to get the codes simplified and now I want to match up the name(s) to the code. Vlookup will only return one value per code unless there is a clever way of expanding its parameters.

Thanks in advance

Paul