matrix

I can't execute your sheet, since I'm limited to Express.

Are you sure that ALL items that you have in the first column of Dim_list occur (Exactly!) in the first row of Prop_list. Note: the names must match exactly, including capitalization if any.

Success!
Luc

Yes, they all match. For some reason it at the end of the if-else loop it says the Prop_list is not a scalar nor vector

I already told you in the other thread that your file won't work for us if you don't provide the input Excel sheet as well. And if you wan to make it easier for us to open your worksheet directly from within the thread you should use filenames without any blanks/spaces (you may use the underline character instead)

Check the label of every occurrence of Prop_list. They should all be the same 'variable'.

Success!

Luc