Hi, above is a works holiday sheet. I want to be able to find out what weeks a specific person appears in. I.e. ‘C.Hipkiss’ has w/c ‘a,b,c & d’ off. I’ve used a VLOOKUP to what find who’s off on a specific date but i can’t figure out the above problem. Any ideas?

​Hi, above is a works holiday sheet. I want to be able to find out what weeks a specific person appears in. I.e. ‘C.Hipkiss’ has w/c ‘a,b,c & d’ off. I’ve used a VLOOKUP to what find who’s off on a specific date but i can’t figure out the above problem. Any ideas?  Read More

​