About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • How can you search for a cell using both the column AND row values? Or is there a different way to go about this?
Best answer

How can you search for a cell using both the column AND row values? Or is there a different way to go about this?

  • 12 November 2020
  • 1 reply
  • 331 views
C

I am trying to take in a specific time and date (from a google calendar event ) and search for a cell value in a google sheet (in which rows = hours and columns = day of the week). I have spent so long formatting the data so that I know which row and column to search depending on the date given in the Google calendar event … Only to realize I cannot search for a specific date using both the row and columns (with search, you can do a custom search on columns but not for rows. With update, it’s the other way around). 

 

Basically, what I am asking is...Does anyone have the solution? I beg!

icon

Best answer by Troy Tessalone 12 November 2020, 18:35

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

1 reply

Troy Tessalone
Userlevel 7
Badge +14

GSheet - Lookup Row relies on data being in a flat file format, meaning one row per record, rather than in a matrix as you’ve described.

As an alternative you could achieve this by using a different GSheet tab that has a formula to lookup the INPUT from the Zap in the matrix tab and returns and OUTPUT in a different cell which the Zap can reference.

In essence, you’re creating a dynamic formula driven lookup.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions