Help on what type of formula should be use?

[RUERIE]

Hi Everyone, I been cracking my head out but I think Excel should be able to resolve just maybe I am not knowledgeable enough...

Am using Excel 2010, I need to provide a formula that can generate the course the student is exempted from and what modules student needs to take in order to complete Course 4

E.G) If Student completed Module ABC, the result should reflect Course 1, 2, 3 & 5.
I would also need a formula that is able to show Course 4 just require Student to complete Module D

I was thinking of using Vlookup with CONCATENATE function.. but that doesn't seem to make it..
Is it possible to generate a formula for this? Appreciate the help and replies!!

Course 1	Module A		Module C
Course 2		Module B		Module D
Course 3	Module A	Module B	Module C
Course 4	Module A	Module B	Module C	Module D
Course 5	Module A	Module B	Module C

<tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>

 

[Redwolfx]

I can't make sense of your Data and your results, If a student took ABC shouldn't Course 2 be left off the list?

 

[RUERIE]

I can't make sense of your Data and your results, If a student took ABC shouldn't Course 2 be left off the list?

Oops.. yes you are right.. I made a mistake in that.

 

[Redwolfx]

Are the modules for the courses Static? Can I hard code Course 1 will always be Modules A and C?

 

[RUERIE]

Yes, they are static. Modules will always be the same for Course 1

 

[Redwolfx]

And where does the information from the Student come from?

 

[RUERIE]

Should be manually inputted on another sheet.

 

[Redwolfx]

And is that sheet in a similar Setup?

Student 1	Module A	Module B	Module C
Student 2	Module A		Module C	Module D
Student 3		Module B		Module D

<TBODY>
</TBODY>

 

[RUERIE]

Currently no fixed setup. As I wasn't quite sure how to come up with the formula
In the previous design, the setup was created like below:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { vertical-align: middle; white-space: normal; }</style>

	Module A	Module B	Module C	Module D
Student 1	✔	✔	✔
Student 2	✔		✔	✔
Student 3		✔		✔

<colgroup><col style="width:65pt" span="5" width="65"> </colgroup><tbody>
</tbody>

 

[Redwolfx]

Are you looking for the information to appear in one Cell? Or could you setup mor e of a form to convey the information? Either one is possible, it will just be a lot easier to set up a form