Most valuable professional
  • Hot Topics

Excel Help on what type of formula should be use?

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 Course 2 Course 3 Course 4 Course 5

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of March 18, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel