# Twilio Glide Zap Connect Issue **URL:** \ **Category:** Ask for Help\ **Created:** [March 17, 2021, 8:34am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395 "2021-03-17T08:34:04Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Eyebrowup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyebrowup/32/15683_2.png) [@Eyebrowup](https://community.glideapps.com/u/Eyebrowup)\ **Post date:** [March 17, 2021, 8:34am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/1 "2021-03-17T08:34:04Z")
Hey there, I’m working my way through connecting and testing a Twilio Glide Zap connection. Can someone tell me why I am getting the #N/A error and how to fix it please. And when I replace with #N/A with an actual phone number (with an international code), the column heading turns to REF! Nonetheless, it’s an error message. Thanks! ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [March 17, 2021, 8:56am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/2 "2021-03-17T08:56:24Z")
The phone field is empty…the other thing is that you are using “;” and “,” this may be causing an issue ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 18, 2021, 5:35am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/5 "2021-03-18T05:35:23Z")
Are there any values anywhere in column D? If there are, that will cause the arrayformula to fail. In your second screen shot, if you hover over the small red triangle in any of the #N/A cells, an error message will be revealed. What does that error message say? ---
**Author:** ![Eyebrowup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyebrowup/32/15683_2.png) [@Eyebrowup](https://community.glideapps.com/u/Eyebrowup)\ **Post date:** [March 18, 2021, 6:12am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/6 "2021-03-18T06:12:20Z")
Thanks! The error reads, " **Error** Did not find value ‘biden@gmail.com’ in VLOOKUP evaluation." I scrolled all the way down. No values in any column beyond row 21. But, in my other app, the formula does work. Maybe there’s something I’m not seeing. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 18, 2021, 6:38am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/7 "2021-03-18T06:38:24Z")
In your Users sheet, does column B actually contain the email address? Have you inserted, removed, or rearranged any columns in that sheet? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 18, 2021, 6:45am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/8 "2021-03-18T06:45:01Z")
Is that first screen shot from your Users sheet? If yes, then that shows the problem The email address is in Column _C_, not Column B. So you need to adjust the VLOOKUP to start from column C `VLOOKUP(B2:B,Users!C:E,3,FALSE)` should do it. ---
**Author:** ![Eyebrowup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eyebrowup/32/15683_2.png) [@Eyebrowup](https://community.glideapps.com/u/Eyebrowup)\ **Post date:** [March 18, 2021, 7:11am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/9 "2021-03-18T07:11:42Z")
THANKS for walking me through this. That did the trick. If you know if any tutorials that walk me through this, I’d like to have it on file. If not, your time has been valued. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 18, 2021, 7:21am UTC](https://community.glideapps.com/t/twilio-glide-zap-connect-issue/24395/10 "2021-03-18T07:21:47Z")
@ThinhDinh did an excellent tutorial on using arrayformulas. It’s almost a year old, but I think most of it is still relevant. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … Arrayformulas are very useful, but as the capabilities of Glide are being extended, they are becoming less necessary. Many things that used to require an arrayformula can now be done natively in Glide using computed columns. This is much preferable, as calculations happen on a user device instantly, and delays caused by syncing with the Google Sheet are eliminated. My general rule of thumb when it comes to formulas is to first look for a way to do it in Glide, and only turn to a spreadsheet formula (or script) as a last resort. Applying the above to your scenario, you could have achieved the same thing using a relation and a lookup column 😉