Multiple Input Variables

Hi there.

I am trying to create an excel spreadsheet which will do the following:

Show a number (which correlates to a task that needs evidence), that across the tables show the types of evidence that could be used.

The difficult part, I need to make it so each type of evidence has a 'sub cell' (not sure what to call it) that will then define whether that piece of evidence is needed for that number, and if yes, has it been provided?

Ive attached the spreadsheet which has the types of evidence, whether its required, and whether it has been provided. Then the numbers are listed on the side.

I understand I could do this simply creating 51 different spreadsheets, however id rather not do that.

Any advice would be very helpful!

Hmm, I really don't know what you are asking. Can you mock up the example file with what you expect to be the results? What's the input and what's the output?