title: Excel: Combine =vlookup and =countif
body: <p>For my question I am trying to reduce a very large amount of data using the =countif function in regards to a specific Employee ID (using =vlookup).</p>
  
  <p>In Column 'A' I have every employee ID listed only once. In columns B, C, D, E, and F I would like to count every time that employee has been Hired, Promoted, received a Pay Increase, been Demoted and Fired, respectively.</p>
  
  <p>In Column 'I,' I have again a list of employee ID's and in 'J' each time one of those actions were implemented. 
  Since there are more than 10,000 employee iterations that exist in column 'I' this is why I am trying to condense these down to numeric values in columns B:F.</p>
  
  <p>ACTUAL QUESTION: Is there anyway to 'nest' these two functions in order to get the required results that I want?</p>
  
  <p>Thanks in advance. </p>