Excel Excel help - macro formula

[NMAR]

I'm using a complex formula on one excel sheet to go down a list of prices on another sheet to give me a specific answer. My problem is how do I get the returned values to be in the same chart with the variables and save specifically to each row, instead of the entire answer column listing only the CURRENT value all the way down. I'm thinking some sort of macro would work but i cant find any help online. Any help would be appreciated!