Formula Help?!?

Hello all,

I’m currently using the Index Match formula at the moment and it works with a work around but would like it find a better function as I’m sure there is one out there. At the moment I have a spreadsheet that shows a job list and then breaks down the information with the different columns,(timescales area, etc) so the index match works brilliant with the way I have the the spread sheet set up to show everything and each worker has a code that I put in and it sends the information to there display box on a different worksheet that’s easy to read. The issue I have is if I want two or more people on the same task I have to copy and paste the row for a many workers as I want on it, which then messes with some of the other formulas I have that counts the number of ongoing jobs and makes graphs and things…. So my question is - is there a function that does the same thing as index match but will allow for multiple entries within the cell so if the code it’s looking for is in there it will accept it, whether that be on a separate line or in “ “. So it accepts a cell currently with “00001” but can’t if the cell contains “00001, 00002” because I have two people working in the same task. Hope this makes sense and will appreciate any and all advice?