Quote:
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
|
If you follow the link I provided you will find that a simple CSE formula suffices
It's not that complicated