Hello,

I'm using the following XLOOKUP to look for two different values in two different arrays and return one array:

Formula: copy to clipboard 
=XLOOKUP(A2&C2,'Netsuite Report'!A:A&'Netsuite Report'!C:C,'Netsuite Report'!F:F)


The formula works fine, but takes a while to process. If I sort a column, the spreadsheet takes about 30 seconds to recalculate.
Is there an alternative formula that will calculate faster?