Sorry if this is a dumb question but I'm quite new to Excel.

I'm happy using functions in a cell where I need to calculate a value for that cell. Now I've hit a problem where I need to calculate a cell address (or addresses) and then push a value to the appropriate address (es). Can I do that and if so how?

It seems that problem was outside the scope of my training so I'm lost. Any help would be gratefully received.

Thanks.