Collating Payroll

Hello,

I'm looking for a formula to analyse a payroll spreadsheet. On the spreadsheet there are a number of names and then it lists a breakdown of what their pay is being made up of (PAYE/NI/SSP etc).

Now these people make up 4 teams between them - so what I want to do is search the column with all the employees names in and if it finds a certain name - pull a value from that row. I would need the foruma to search for multiple names and then add up all the values from a set column.

The difficulty is that the same people will not be paid each month - so the payroll export could look different from month to month. This could possibly create a problem whereby if for example you seached for the name 'JANE' (which was found in row 6) is would pick up the value in H6 - the next month however is 'JANE' was found in row 5 - it would need to pick up the value H5. So the formula would not pick up set cells, but depending on the row the search value is found it would take a value a number of cells along - i.e be flexible.

As an Example (Very Basic)

--------A---------B
1------JANE ----10
2------DAVE----10
3------JOHN----10
4------TOM------5

Team 1 is made up of Jane and John - so the foruma needs to search from A1:A4 for those names, and if found add the values of 1 cell along together.

Thank you in advance for your help.