Data coming from different spreadsheet.

B25 = local cell which you are using for the search
URL = url from separate google sheet
sheet1 = name of other sheet your pulling data from
!a1:e = range of the search
After the search
3 = which column you wish to pull the data from
false = will your results be sorted?

If you get #REF when you first try this, just click your mouse on that and it will bring up a “allow access” dialog. You need to allow access if your pulling data from another spreadsheet.

Here’s how to locally pull data from another sheet.  For example, you have a sheet1 and sheet2.

B3 = cell you want to use for search

Sheet2 = Sheet your pulling data from

!C3:E3 = range you want to pull data from

3 = which column you want data from

false = results will not be sorted.

This typically happens if the files (ie pictures) originated from a Windows host.  I’ve found it’s much easier to just remove the spaces in the files than to deal with trying to properly quote your escapes in your loops.  

All words only.

All words and digits

Sometimes piping to less on each is helpful depending on how big your file is.