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

Question

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!

Troy Tessalone · Accepted Answer

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.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded