Best answer

Lookup multiple columns in Excel

  • 21 September 2020
  • 2 replies
  • 318 views

Userlevel 1

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

icon

Best answer by Troy Tessalone 21 September 2020, 00:40

View original

2 replies

Userlevel 7
Badge +14

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.

Userlevel 1

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 :-)

Reply