Inputting values from array to get multiple values

Hello fellows, hope any of you can help. 

To make long story short I have a very complicated formula where I need to enter 2 values for excel to return another value.

Simple example of what I’m trying to achieve is as follows:

Let’s say you need to enter width and height for excel to return the surface area

 

Is there any way I could get it to fill the table where every column is different width while all the rows are different heights?

 

 

By: Vito

One thought on “Inputting values from array to get multiple values

  1. Vito

    Btw, I cannot copy the formula itself, the values in the new table has to be references to the cell which returns the value

Leave a Reply

Your email address will not be published. Required fields are marked *