COUNTIF and VLOOKUP

Hi All,

I have a list of jobs per employee throughout the year, at the end of the list I want to do a count based on customer, however the customer names are not on this list.

So at the moment I have the entire list replicated with each cell having a VLOOKUP to return the customer. then just do a countif at the end of that table.

I was wondering is there a way to do this without duplicating the entire table, as these are huge tables

I was thinking some sort of =COUNTIF(VLOOKUP("JOB","RETURN CUSTOMER),"CUSTOMER"), however i would need this to run this formula on every line of the list to find out if the customer matches the countif criteria

Hope this makes sense

Thanks in advance

1234568900

Thanks for your interest,

Please see attached example workbook, I have been trying different things and have found another problem

On "sheet 1" is the table of employees and the job number they worked on, just below is the list of customers and the amount of days the employee worked for that customer. the customer data can be found on Sheet 2

However a simple vlookup wont work, as seen in the example, in column B, both 9999 and 7777 are the same customer but different job numbers, my vlookup stops after finding 9999 and doesnt look for 7777.

Hope this makes sense, not sure if its possible, there are of course work arounds but i try to keep my workbooks neat and tiday

Thanks for your time, I was aware of the way you have suggested, which is looking like the best way.

I was just looking for another way to avoid making an already large workbook larger. Not to worry, it works and thats whats important

Thanks again