@Joe_Smith
If you have valid members in your club membership the membership option will work with some exceptions.
If you clone matches it may not work. If you create matches more than 2 months in advance it may not work.
Currently you have a old template match I believe you are cloning from.
The Exportable spreadsheet is created from the match registration. The membership database does not integrate.
I personally do not use the membership discount option. I use the Price adjustment option and double check that all discounted shooters are actually members. Price adjustment also lets you offer other pricing such as Juniors or Seniors or Vets.