Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Lookup in Excel failing, row not found

  • May 25, 2021
  • 4 replies
  • 68 views
J
Forum|alt.badge.img+1

Hi,

 

I have a Zap that is trying to lookup a date in a column in Excel but keep getting the error

 

‘Bargle. We had trouble getting a matching find row. :-(Error details: Nothing could be found for the search.’

 

even though there definitely is an entry there it could be picking up.

 

I’ve done a video at https://www.loom.com/share/8e04a5f458e34fc2b7132a871e2f5f26 if anyone might be so kind as to have a look and let me know if I’m doing something wrong and how I could get it working?

 

Any help would be greatly appreciated :)

 

Jon

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • May 25, 2021

Hi @Jon Hall 

Troubleshooting Tips to Try:

  1. Try making sure there’s a value for every cell in that column
  2. Adjust the format of the Date in the Excel and Zap to YYYY-MM-DD
  3. Try setting the format of the column in Excel to be a Date type
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
J
Forum|alt.badge.img+1
  • Jon HallBeginner
  • Author
  • Beginner
  • May 25, 2021

Hi,

 

Thanks for your suggestions. I’ve tried tips 1 and 3 and they didn’t change it.

 

I could change the format of the dates as in tip 3 but it would take a lot of adjusting elsewhere - do you feel this would make it work?

 

Jon

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • May 25, 2021

@Jon Hall 

Might be best to open a ticket with Zapier Support to have them troubleshoot further: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
J
Forum|alt.badge.img+1
  • Jon HallBeginner
  • Author
  • Beginner
  • May 25, 2021

Hi,

 

I’ve gotten it working by changing the format the date is displayed in in Zapier even though that doesn’t seem to be how it’s displayed in Excel. M/D/YYYY in Zapier picks up the date shown as DD/MM/YYYY in Excel. But it’s working so that’s great :)

 

Thanks for your help :)

 

Jon

Terms & ConditionsAccessibility statement