Vlookup

  • Thread starter Thread starter Kevin Carter
  • Start date Start date
K

Kevin Carter

Hi

i have a table containing differnet types of holidays
Vac
Spring
bank hol
in column A i have the week number from a7:a740
in column B i have the date
in column C i have the day
in D6 to M6 i have the employee names
in D7 to m740 i enter the type of holiday the employee has taken.
What i want to search column A for the week number then count the number of occurrence of a holiday type for each day

i have tried

=COUNTIF(D9:M9,"Vc") works fine but i need to count only occurences for a given week number

is vlookup the best solution for this?
and if so can i use count if with Vlookup

thanks

kevin
 
Hi

i have a  table containing differnet types of holidays
Vac
Spring
bank hol
in column  A i have the week number from a7:a740
in column B i have the date
in column C i have the day
in D6 to M6 i have the employee names
in D7 to m740 i enter the type of holiday the employee has taken.
What i want to search column A for the week number then count the number of occurrence of a holiday type for each day

i have tried

=COUNTIF(D9:M9,"Vc")  works fine but i need to count only occurences for a given week number

is vlookup the best solution for this?
and if so can i use count if with Vlookup

thanks

kevin
Click to expand...

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com
 
Back
Top