I need help. The pair function in my app always using the 1st column of my excel data as keyword to search for the pair in column two. Any way to use the data in 2nd column as keyword to pair for column 1?
If you downloaded your entire data table, you can filter it using procedures in this sample app … https://docs.google.com/document/d/12t4HLNRepCnbmcfycdF8wSHWht_D1P8hKJpTknVDChY/edit?usp=sharing
If your Google Sheet is large and you want to filer upstream, see FAQ Section: Google Sheets