VBA Loop if match the 1st criteria, then search and return the partial match value

[Faceless Judge]

Hi All,

Referring to the attached image, assuming I have two sheets (Report and Raw Data). As you can see, under "Raw Data" sheet, each ID might have multiple customer name and each customer name might have multiple ID. Thus, I wish to first match the ID then lookup and return the value from "Raw Data" sheet to "Report" sheet.

eg. Of "Report" sheet, "A6" is 1000 with "B6" customer name Alex Mayer. But in "Raw Data" sheet, ID 1000 has two different names and the customer name Alex Mayer appear to have two IDs.

Please look at the image attached for clearer picture. Kindly help on the VBA folks.

 

[pbornemeier]

So you want both of the names with the matching ID to be returned to the Report worksheet?
Please use XL2BB to post your worksheet data (see last link in reply window). It allows use to easily copy the data you provide into a workbook.