Originally Posted by Purfleet

That is exsactly what index and match do (and vlookup) it finds the first one.

if you want it to find all it will be a lot more work, but sometimes a Pivot table might be a quick win.

As Marcia said always add a work sheet example