Simple Program for Compiling Data

Hey,

I'm new to programming in excel, though I do have some experience in MATLAB and MAPLE (ME grad student). I have a fairly complicated spread sheet for a design optimization project and all I really want to do is create some graphs of a variables (ranging from its bounds, while keeping the other variables constant) versus certain outputs. Since the output formulas depend on 20ish other calculations its not quite as simple as copying and pasting a formula.

Essentially I want to automatically create a list of output values from a particular cell when another cell (that the first cell depends on) equals a certain array of values. I'm doing this so I can create a graph and see trends in certain outputs as a variable changes value.

I know this has got to be a simple program, I just have limited time and am sure someone could show me this in like 5 min.

Any help would be greatly appreciated.

Thanks, yes that's it, basically creating a loop to vary the input variable and display the output variable in a list.

Ideally all I really need is a function that would do this: =WHEN(Sheet1!$D$23=Sheet2!B2, DISPLAY=Sheet1!$G$36) but I couldn't find a WHEN function....

Ah exactly what I need, thank you very much for the help and quick response.