Lookup two values in two arrays - return one value

Hello,

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

Formula:

Please Login or Register  to view this content.

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?

If you limit the ranges to something sensible, rather than using entire columns, it will be a lot faster

Thank you, that worked.

You're welcome & thanks for the feedback.