[Scott]

Katana.. Do you have the password to un-protect the cells? The biggest hurdle here is the language, and not being able to pry into the excel formula.

It's more complicated than just building an array. If you look at how cell E are calculated on the first tab, you will see that not everything prefix+item+suffix but there are also conditional statements...