I have a great idea in my head for a dashboard project in g sheet, however, with my limited knowledge I'm having trouble to assemble the proper formulas to actualize it.

I want to check a vertical range of cells. If the cell contains time above 2:00, index the cell in column 1, Otherwise, write "No tours". (All the cells in the range contain value "")

The table and the needed results marked with green on the right In the following example, I want him to index me A13,A24,A28

Since I couldn't solve the first problem, I haven't integrated hlookup yet.

I would be really glad if you could help me to figure out how to properly approach this issue.

CodePudding user response：

It sounds like you just need this:

=IFERROR( FILTER(A:A, I:I >= TIME(2,0,0) ), "No Tours")

CodePudding user response：

This might be what you're looking for?

=IFERROR(FILTER(A:A,I:I>2/24),"No Tours")