Index match values from a table

user_17126932 0
Viewed 44

I am trying to use an advanced VLOOKUP (index small match) formula in my table, but somehow can't figure out what's wrong, it only prints one cell.

I want the formula to print (in list) all the cells from column A, that contain time above 2:00 in column J.

Link to the spreadsheet

I have attached both a screenshot and a link to my table, please help me out.

Table screenshot

vlookup google-query-language google-sheets-formula google-sheets filter
1 Answers

try:

=FILTER(A:A, I:I>0.08333333333, I:I<>"")

enter image description here

user_56326290
Related