Hello,

On a excel sheet, I created a table that, from two values (heat and building) calculates the running time of a cogeneration unit. To do this, I created a table with various columns, references to tables in the same sheet and to tables in other sheets. The table is 19 rows by 11 columns.
But I have many builiding/heat combination to calculate. And I would like to avoid having to duplicate this table hundred times.

What I would like to do is use this table as a function. Something in VBA for example that I could use as =runningtime(heat,building). Please find an example attached. Table as a function.xlsx

Does somebody habe an idea on how to do this?

Thanks a lot for the help,

Nicolas