Guess it my week for questions. :) Trying to figure out how to create a grid with "x" indicating a match of names and dates. It's a duty assignment schedule for clarification. The attached has a sample, but I've been playing with
=INDEX($E$1, MATCH(1, ($J3=$F$3:$F$18)*($L$2=$G$3:$G$18),0))
It seems to work in the first cell, but then when a name repeats I get a Ref# error. Other variations give me the N/A error. Looking for a nudge in the right direction and as always I appreciate the help in learning how to do new things!
WHH3
Bookmarks