Why Does XLOOKUP throw out an Error when I copy and Paste it? It's on the same worksheet and it's the same data?

Basically I am baffled as to why XLOOKUP will work sometimes when I copy and paste it and why it throws out #NA when I am simply copying and pasting it again?

I copied my entire rows with everything in it to duplicate working space for capturing data and it worked, so I could save time and get work done.

Now I repeat the same process and I get #NA with some cells and others work just fine?

Is this a microsoft office flaw which requires fixing?

I am grateful for the help thus far, but this literally doesn't make any sense from what I've studied on XLOOKUP and FILTER functions... If the Reference data remains unchanged or in the same location it shouldn't give the #NA... there are copy and paste versions that worked before, but now it does this everytime.

Formulas used:

=XLOOKUP(O7;Table11[PROD. CODE];Table11[Supplier];"")

=XLOOKUP(O7;Table11[PROD. CODE];Table11[SIZE];"")

=XLOOKUP(O7;Table11[PROD. CODE];Table11[Supplier Price];0)

=XLOOKUP(O7;Table11[PROD. CODE];Table11[RETAIL];0)

The above seem to almost have almost never thrown out errors.

Only recently after my new updates are there errors when I copy and paste the rows and columns exactly.

The ones that are giving errors mainly are the following:

=XLOOKUP(V8;'STATUS TABLES'!D3:D8;'STATUS TABLES'!E3:E8;0)

=XLOOKUP(X8;'STATUS TABLES'!F3:F8;'STATUS TABLES'!G3:G8)

=XLOOKUP(AH13;'AGENT INFO'!A2:A24;'AGENT INFO'!B2:B24;0)

=XLOOKUP(BB16;Table11[PROD. CODE];Table11[Supplier])

As stated above, it makes absolutely no sense to me at this point, the sheet is formatted to General, and I ensure that the newly copied Cells all carry over the exact same information, linked to tables which I never alter, so the reference data stays the same in the same Sheet.

Apologies, I'm no expert but I'm learning the logic of the new Office 365.