Search code examples
google-sheetsfiltergoogle-sheets-formulavlookupgoogle-query-language

Index match values from a table


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


Solution

  • try:

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

    enter image description here