It's an Array and requires confirmation using CTRL + SHIFT + ENTER rather than just Enter per a "normal" formula. If the Array has been set correctly the formula will appear encased within { } [note these can not be added manually]

If you have follow ups please create your own thread and add a link to to this thread if still relevant.