Is there a way to reference an individual cell/row/column in the results of a FILTER function in Excel

I know I can reference the whole result of a FILTER function with cell reference plus #.
In this case F40#enter image description here

Is there a way to reference a particular "cell" in the result of a FILTER function?
In this case I want something like F40#(.Cells(2,2))

>Solution :

You can use INDEX

=LET(f,FILTER(Table4,Table4[qty]>10),
INDEX(f,2,2))

Leave a Reply