Multi-cell array problem

[borowik]

Dear All,

I am trying to return stock price for a particular 'ticker' and date, using index-match formulas. I did manage to get it work, but this has become an array formula, which I am not able to copy-paste.

I tried to apply the multi-cell array concept by selecting the range and pressing ctrl + shift + enter - and indeed this operation helps to put the brackets in the whole range but the row of the date cell stays the same for some reason.

Please Login or Register  to view this content.

Do you have any idea on how to proceed?

Thank you

[borowik]

All, just have solved it! Having spent 5 hours on that and posted here, I realised I just had to select the cell and drag it down...