These are the values I am passing to my spreadsheet. In column A, I have the scheduling IDs, and in column B, I have the cell phone numbers of the people who scheduled (the numbers do not exist, they are just there for testing purposes).
I want to know if it’s possible that whenever I specify a phone number from column B, I receive the ID from column A.
Welcome to the Make community!
You can use the Google Sheets “Search Rows” module. This will allow you to search rows containing the phone number in column B.
4 Likes