I dont know either my brain is boggled. lol When I use the formula in column C it does what the vlookup did with column B, doesnt catch all of the values. I am not sure I can do what I am wanting to do. Especially since any of the 5 modules could have values in any combination. Ive learned alot of excel in the past couple of weeks and still learning these higher level formulas and such.

You guys have been a big help and now Im closer to victory.