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!
Best answer by Troy TessaloneView original
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.