I'm interested to know whether (and how) can i call IMPORTRANGE function inside of REGEXMATCH function.I want to get root domains from list of URL's and use REGEXMATCH to do this but want to get list of all possible TLD's from other sheet to avoid specifying com|net|org|all other by hand.Basic idea:  =REGEXEXTRACT(A2, \w+\.(?:com|net|org))What I want:   =REGEXEXTRACT(A2, \w+\.(?:IMPORTRANGE($SHEETKEY,!A2:A)))Any way to achieve this?
Calling IMPORTRANGE inside of REGEXMATCH function?
google spreadsheets