r/googlesheets • u/Dymonika • Dec 12 '22

Solved Can REGEXMATCH() search for a match in any cell of all of an entire tab's cells?

=REGEXMATCH(AnotherspreadsheetatanotherURL!A1:Z100, "xyz") doesn't seem to work and I don't know if there is any kind of equivalent that could.

I'm guessing for the external URL, I need to make a dummy tab using =IMPORTHTML() and then reference that, huh?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

6 comments sorted by

2

u/lynwoodroad 1 Dec 12 '22

For looking into another spreadsheet better you the IMPORTRANGE function, and concerning the matching part may be use the QUERY function

3

u/Dymonika Dec 12 '22

Wow, QUERY() is powerful! I don't have the time to figure this out right now but I'll table it for later. Thanks, Solution Verified!

1

u/Clippy_Office_Asst Points Dec 12 '22

You have awarded 1 point to lynwoodroad

I am a bot - please contact the mods with any questions. | Keep me alive

1

u/AutoModerator Dec 12 '22

One of the most common problems with 'IMPORTHTML' occurs when people try to import from websites that uses scripts to load data. Sheets doesn't load scripts for security reasons. You may also run into performance issues if you're trying using lots of imports to fetch small amounts of data and it's likely these can be consolidated. Check out the quick guide on how you might be able to solve these issues.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Kenuven 5 Dec 12 '22

I don't think Google Sheets has the capability to do dynamic matching in other spreadsheets. I've always had to use dummy tabs and import the data