Is the issue that the location of my data is in a different area
yes
beside this is array formula You have to accept this with CTRL + SHIFT + ENTER (not simply ENTER)