How to decide which column of the data as keyword to pair

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 …

If your Google Sheet is large and you want to filer upstream, see FAQ Section: Google Sheets

You can simply do this:

if your data is in a List form (myList). Swap the ‘pairs’ in the List as in Button2 or not (as in Button1)


Does the example work for you?