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