Hi there,
I have a Zap that does a lookup in Excel for a user’s email address and if not found the zap will add the user to the Sheet.
I need to update the zap so that i can look up on multiple columns, example Email + Lastname. If this combination is not found in the sheet then only i would like to add the user to the sheet.
I looked around but there is no information on how to lookup on multiple columns. Can someone please let me know how i can achieve this.
Thanks
R
Best answer by Troy Tessalone
You could add a column to the Excel file that does a CONCATENATE of the Email Address and Last Name and use that column as the lookup column in the Zap.
+14You could add a column to the Excel file that does a CONCATENATE of the Email Address and Last Name and use that column as the lookup column in the Zap.
thanks Troy, thought about that option. I have an organization document given and that document was using Google sheets. In there i could see the previous admin was able to use “Supporting lookup column”….I was wondering if there is something like that for Excel also. If there isn’t then concatenating is my option i guess :-)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
