Hi Bernd,

The ctrl+shift+enter does not work but I entered it as array formula
(INDEX(array,row_num,column_num)).

I can see that the result is correct while entering the formula (before
clicking ok) but the result doesn't show on the spreadsheet...

Thanks
Deborah

" wrote:

Hello Deborah,

Your formula looks ok to me.

You just have to enter it as array formula (with CTRL + SHIFT + ENTER).

HTH,
Bernd