it sure does. and many thanks for your help but i cant condense the workbook into a single formula or a formula capable of going into a row which can be replicated into each row since my workbook is made up of hundreds of formula all iterativley doing their own thing. its too complicated.

i just need to be able to feed this complicated workbook with a list of inputs then output the list of outputs.

i think on further research i might be looking for "data tables". what do you think?