I’ve been trying to set up a formula to show if someone has paid their membership fees. They can either pay yearly or monthly. The yearly formula seems to be working but the monthly formula seems to not work. Basically, I want it to show – if the month referenced is either the current month or a later month – if the person named for that row has paid for that month. If possible, I also want to show if someone has said they’ve paid but the payment isn’t showing in the bank.

This is the ‘Income – Membership fees’ sheet referenced in the formula.
image 1

And this is the main sheet and the formula:
image 2

I’ve tried using vlookup, and * instead of AND. I’ve also tried looking into byrow, lambda, and match but I don’t know if they’re the right thing for me to use.