Need to compare value of a column to a querie , but it exceeded the number of rows

[cssfonseca]

Hello,

Daily i need to check if a number of values exists in a database. That database if available through a link, which i imported to excel to a querie and then to a worksheet.
The problem is, now the report exceeded the number of lines in excel and i can't accurately verify if those numbers exist.

So..
My file as a column A with the values i need to verify in the database, and a column B where it returns (through a combination of if na, index & match formulas) if exists or doesnt exist.
Everytime i refresh the querie (the reported is generated daily), now it shows me the message that the rows don't fit in the worksheet.

formula i use: =IF(LEN(A2)=0;"";IF(LEN(A2)<10;"EAN is short";IF(ISNA(MATCH(TRIM(A2);'EAN & ID'!A:A;0));"EAN doesn't exist";IF(MATCH(TRIM(A2);'EAN & ID'!A:A;0);"EAN exist";"EAN doesn't Exist"))))

I loaded to a model, but i don't know how to reference in a formula and i don't seem to find that information online (maybe i'm using the wrong combination of words on search), or if i should load through a different software like PowerBI or Access.

Can you help me?