I’ve been grappling with this question for a couple of weeks and am edging closer but I’d love some help.
Basically what I’m doing is trying to build an automated calendar, where on one page you can put in a communications piece and the week that it gets released, and that will automatically feed into the calendar on the next page. The calendar has the week starting dates in a row at the top and the communications pieces in a column down the side.
So how can I express in a formula something like: when the values in columns A & B of page 1 both match row a & column b on page 2, input an X (or colour or whatever).
Any help is kindly appreciated!