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

MIT App Inventor Help
1

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?

2

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

3

You can simply do this:

swapPairs
swapPairs890×708 120 KB

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

keys

Does the example work for you?

Regards,
Steve